sqlfriends (4/18/2013)
Thanks, that is a good alternative. I ended up adding that account temporily into database as dbowner when backing it up, after done, I removed it from original database.So when restoring to antoher server, it has dbowner buildin it.
Well,
That will work if you are using a Windows login. If you are using a SQL login, it will not. You will have to reset the SID on the target database, as they are different. You must also create the SQL account / Login at server level, on target as well.