andyrobins
Technical User
Hi.
We are about to migrate a sql7 database onto a new sql2000 cluster and are wary about orphaned login issues within sysusers. Now I ahve found many thing about how to fix SQL Server logins using sp_change_user_login (I think that was it!) but there doesn't appear to much on what to do about Windows logins. Is there an easy way to purge the sysusers table from the new database so that we can just run a script built from the original servers syslogins and sysusers? Or is it best to try and map the SID in sysusers to the new SID created when adding to new server's syslogins?
Thanks in advance
Andy
We are about to migrate a sql7 database onto a new sql2000 cluster and are wary about orphaned login issues within sysusers. Now I ahve found many thing about how to fix SQL Server logins using sp_change_user_login (I think that was it!) but there doesn't appear to much on what to do about Windows logins. Is there an easy way to purge the sysusers table from the new database so that we can just run a script built from the original servers syslogins and sysusers? Or is it best to try and map the SID in sysusers to the new SID created when adding to new server's syslogins?
Thanks in advance
Andy
