Hi everyone...
On two instances of SQL Server 2005 I am using the same SQL login names, but the SID is different for each one. I would like to synchronize these IDs so that when I restore the production database to the developement database I don't have to remove and re-add the logins.
Is there a quick and easy way to do this?
Thanks,
Forch
You can create a login with the same SID on the second server using the SDI = sid option on CREATE LOGIN DDL (http://msdn2.microsoft.com/en-us/library/ms189751.aspx).
-Raul Garcia
SDE/T
SQL Server Engine
|||While it will take a lot of manual effort, it will do the trick. Thanks!
No comments:
Post a Comment