Database logins

Last Post 19 Mar 2010 01:59 PM by gunneyk. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

19 Mar 2010 06:55 AM
Is there a way to review the logins for a database in SQL 2005?  I am trying to review servers for databases that have single sign ons and not windows groups as the logins.

I know the sp_helplogins process on each login. I am looking for a script or view that will show this information if one exists.

Thank you
New Member
New Member

19 Mar 2010 01:59 PM
Take a look at the sys.sql_logins and sys.server_principles views. This kb might give you some ideas as well:

Acceptable Use Policy