Monthly Archives: May 2014

Sync’ing sql server authentication logins between mirrored or logshipped databases in SQLServer

To Sync SQLServer authentication logins between mirrored instances: First create the login on the source database. Execute the below code in ssms on source server master database Copy the name and sid and use the same sid when you are … Continue reading

Posted in SQL Server DBA Stuff | Tagged , , , | Leave a comment