Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 sp_resolve_logins

Author  Topic 

chris_cs
Posting Yak Master

223 Posts

Posted - 2012-04-30 : 05:21:18
I'm trying to sync the users between a principal and mirror server using the sp_resolve_logins proc but it isn't doing as expected.

I used BCP to backup the syslogins table on the principal and ran the proc on the mirror database which ran successfully. However, the logins from the principal don't exist on the mirror.

Do these logins have to be imported separately?

----------------------------
Junior DBA learning the ropes
   

- Advertisement -