SP_HELP_REVLOGIN for SQL Server 2005

Published 04 September 07 06:54 AM | SQL Master 

SP_HELP_REVLOGIN stored procedure helps you to generate a script that can be used to recreate the logins that exist on a server at a specific point in time script the logins along with password. I'm not sure how many DBA are aware of this Stored Procedure and it is described in KB article 246133. Though it talks about SQL Server 2000 version within the SQL 2005 the change of system tables fashion it has been changed to include the view master.sys.sql_logins (new in 2005) to get at the varbinary passwords like you did in your Sql Server 2000 scripts (instead of using passwords from master.dbo.sysxlogins).

Here is the script for SQL Server 2005 proposed update of sp_help_revlogin that uses the correct system tables.

Comments

# Other SQL Server Blogs around the Web said on September 4, 2007 7:39 AM:

SP_HELP_REVLOGIN stored procedure helps you to generate a script that can be used to recreate the logins

# SSQA.net - SqlServer-QA.net said on September 4, 2007 8:04 AM:

SP_HELP_REVLOGIN stored procedure helps you to generate a script that can be used to recreate the logins

Anonymous comments are disabled

About SQL Master

**__________________________________** SQL Server MVP, Sr. DBA & industry expert. - Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.