Database logins

Last Post 19 Mar 2010 02:59 PM by gunneyk. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
PaulMcKibben
New Member
New Member

--
19 Mar 2010 07: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
gunneyk
New Member
New Member

--
19 Mar 2010 02:59 PM
Take a look at the sys.sql_logins and sys.server_principles views. This kb might give you some ideas as well:
http://support.microsoft.com/kb/246133/
You are not authorized to post a reply.

Acceptable Use Policy