I was using dts to try to copy a single table (using the copy objects
process) from one SQL DB to another and got this error:

[Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on
object 'sp_grantdbaccess', database 'master', owner 'dbo'

I am the owner of both the sending and receiving DBs. What is the problem
here?

Wayne

Did you pick your databases in the connections properly? Sounds like you
may have tried to copy the table to the master database instead of your user
database.

--
Simon Worth


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

Thanks for the response. With me, all errors are possible! I will keep an
eye out in the future.

Wayne

"Simon Worth" <REMOVEFIRST_simon.worth (AT) gmail (DOT) com> wrote