We are in the process of upgrading to SQL 2K5 from 2K.
Our DR plan is such that we take our 2 production SQL servers and combine them into 1 DR SQL Server. One of them becomes the master and then we attach the other databases. I was copying the sysxlogins /syslogins from SQL_2 to a DR info DB and then could import that into the master on SQL_1 at the DR site.
Withe the change that you can no longer touch the system tables, I'm going to have to resort to using the sp_help_revlogin (http://support.microsoft.com/kb/918992/
) to transfer users.
What I'm looking for is some way to write the output to a table in a database other than master or to a text file using a SQL agent job or scheduled task.