Re-generating SQL Server Logins

Posted on SQL Server Central See other posts from SQL Server Central
Published on Tue, 08 Feb 2011 07:00:00 UT Indexed on 2011/02/08 23:32 UTC
Read the original article Hit count: 274

Filed under:
SQL Server stores all login information on security catalog system tables. By querying the system tables, SQL statements can be re-generated to recover logins, including password, default schema/database, server/database role assignments, and object level permissions. A comprehensive permission report can also be produced by combining information from the system metadata.
SQL Monitor The Future of SQL Server Monitoring
"Being web-based, SQL Monitor 2.0
enables you to check on your servers
from almost any location" Jonathan Allen.
Try SQL Monitor now.

© SQL Server Central or respective owner