June 7, 2006 at 6:23 am
I'm trying to copy the tables from one database to another using the Data Transformation Services. The Copy SQL objects task function to be specific and it keeps throwing up the same error; "The Login already has an account under a different user name".
I'm losing my hair here any help???
The database owner is the same for both databases and this must be kept just so. I've managed to copy the database by deselecting the "Copy dbowners and users option" under the Copy tab of Copy sql Object tasks properties function.
However this error has popped up Invalid object name 'dbo.NCI_ATTR_VALUE_NUM'.
How do I verify that all the selected tables have been copied across successfully
June 7, 2006 at 6:42 am
Jonathan
Check the properties of the task and make sure you're not copying any users or logins. It sounds as if SQL Server is having difficulty copying a user or login that already exists at the destination.
John
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply