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.)
0 comments:
Post a Comment