March 15, 2005 at 7:18 am
Hello,
MSSQL 2000/SP3
I have a user that is DTS'ing data only, from server1.database1.dbo.table1 to server2.database2.dbo.table1. The tables pre-exist and are identical. The develeoper has db_datareader and db_datawriter in both databases. He gets the following error using Enterpris Manager DTS import wizard (from his workstation), using Option#1, "Copy Tables and Views from source database":
"Error at Destination for Row number 1091. errors encountered so far in this task: 1. The current user is not the database or object owner of table 'Database2.dbo.Table1'. Cannot perform SET operation".
When I run same DTS, connected as a similar user with same permissions, from my workstation ... it works?
Anybody seen this SET error or have any ideas?
Many thanks. Jeff
March 15, 2005 at 10:23 am
This could be the bug mentioned in this KB article. http://support.microsoft.com/default.aspx?scid=kb;en-us;302621
Another thing that occurs to me is if 'Delete rows in destination table' or 'Drop and recreate destination table' is checked on the Column Mappings tab of the wizard, the person running it must be a member of sysadmin, db_owner, or db_ddladmin.
Hope this helps.
Greg
Greg
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply