October 11, 2006 at 9:21 am
I have a Production DB Server and a Development DB Server. The development server as so acks as a backup Prod server. What can I do and how to keep the ids the same either through a export/import process or something else? Thanks
October 11, 2006 at 10:15 am
ids can be transfered between machines using the following script
http://support.microsoft.com/kb/246133
Also if using Log Shipping or Mirroring for your backups, it saves lots of security issues having all of the SQL services running under a single Windows ID.
Good luck
Eric
October 12, 2006 at 10:15 am
I have tried that script (http://support.microsoft.com/kb/246133) in SQL2005, but I was getting the below error:
Msg 208, Level 16, State 1, Procedure sp_help_revlogin, Line 12
Invalid object name 'master..sysxlogins'.
.
October 12, 2006 at 12:28 pm
Does this type of process require them to be on a domain? Can it be just in a workgroup?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply