I am trying to use DTS to copy tables, using copy objects, from one DB to
another and after about 10 min of processing I get an error:

"...EXECUTE permission denied on object 'sp_grantdbaccess', database
'master', owner 'dbo'.

How do I get by this? I do not own the server - I just have an SQL database
account there.

Wayne

Are you trying to copy over logins?



"Wayne Wengert" <wayneDONTWANTSPAM (AT) wengert (DOT) com> wrote

Hi,
when you say copy objects, what objects you try to copy, tables? views? I
think you may try to copy the login user id from one server to another, that
could prevent you from moving the login object, I guess...

Ed

"Wayne Wengert" wrote:

I was trying to copy just tables, views and Sps. Should I copy the logins
first?

Wayne


"Ed" <Ed (AT) discussions (DOT) microsoft.com> wrote