SP_HELP_REVLOGIN for SQL Server 2005

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...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2007/09/04/1866.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1866" width="1" height="1">