Hello:
I am getting an error:
User id 12 is not a valid user in database Dest_db
While using Database object transfer.
Using mixed security on the source database.
copy data and replace existing data options are selected.
Printable View
Hello:
I am getting an error:
User id 12 is not a valid user in database Dest_db
While using Database object transfer.
Using mixed security on the source database.
copy data and replace existing data options are selected.
When you move security information from one server to another you must maintain the foreign key relationship between master..syslogins and userdb..sysusers. Recreate security on the destination server and this error will go away.
------------
Kurian Thomas at 6/17/99 1:02:27 PM
Hello:
I am getting an error:
User id 12 is not a valid user in database Dest_db
While using Database object transfer.
Using mixed security on the source database.
copy data and replace existing data options are selected.