Login Transfer Task w/ SID - Is sp_resolve_login needed?

Last Post 13 Aug 2007 06:13 PM by mattssi. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

13 Aug 2007 06:13 PM
I'm trying to set up log shipping and as part of it, the login transfers.

When I set up the Transfer Task with IS, I chose to transfer the SID also. When I test with NT accounts and SQL logins, and I run these commands (before sp_resolve_login is run), the SID's seem to be the same...

select name, sid from master..syslogins where name in ('testUser')

select name, sid from LogShipTest..sysusers where name in ('testUser')

If this is the case, what is the poitn of running the sp_resolve_login?

Acceptable Use Policy