Script To Transfer Logins From SQL Server 2000/2005

A few years back when I was working on a project to with some Dynamics databases, I found a script on a Microsoft site that can capture SQL Logins for SQL Server 2000 and 2005 instances. The script is very useful for transferring SQL Logins not only to 2000 and 2005 instances but also 2008, 2008 R2 and 2012 as well. Since I can no longer find the link, I decided to upload the script – Capture_Logins.sql.

With the launch of SQL Server 2012 and the upcoming release of SP1, many people may be considering upgrading their 2000 and/or 2005 instances and this script might save you a great deal of time. Remember it isn’t my script aka I didn't write and I don't own it. Enjoy!

(Note: Even though the script mentions that it works on SQL Server 7.0, I didn’t test it on that edition so I can't guarantee that it works.)



Community Links

Blog Archive