SQL Server Performance Forum – Threads Archive
Login Fixed Server and Database Roles
How to find what are the existing logins in the SQL Server instance and also how to find what fixed server and database roles are to the logins in an sql server instance? I have 35 SQL servers in my environment and need to prepare spreadsheet for login and their fixed server and database roles information. Any help is greatly apprecciated. Thanks, BKBhushan Kalla
maybe you can start with exec sp_helplogins
Read thishttp://vyaskn.tripod.com/sql_server_security_best_practices.htm
http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?faqid=193
since this is sql 2005 Read Security Catalog Views in BOL Madhu
]]>