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?