Hi

I'm running a simple copy database objects DTS between two databases on
the same server as sa.

However, right at the end of the dts, I get the following error:
SETUSER Permission denied in database 'XXX'

where XXX is the destination database.

Any ideas?

Regards
Ray

Hello Ray,

I have just never had much luck with the Transfer Objects task and I will
always look for ways not to use it. Why are you using it? If you simply
want to transfer data then using this task is expensive. if you want to
make sure that you have the object structure update and kept in sync I would
question doing this in this way as well. I would always use scripts.



Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Hi Allan

I use it because its the easiest to quickly transfer the data across.
At the moment we have a holding database that holds a set of data our
developers are using to test our application across. Its pretty quick
to use DTS to copy the objects across to your own dev database.

What would you suggest?

Regards
Ray

Allan Mitchell wrote:

Interestingly enough, it works with other users in the domain that are
part of the system administrators group. Just not sa.

Allan Mitchell wrote: