Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag xp_logininfo Rss

   Items 1 to 2 of 2   
 

Query accounts, domain groups, and members who have admin membership.

This script leverages master.sys.server_principals and xp_logininfo to return accounts, domain groups, and members in a SQL Server admin fixed role.  Read more...
By Eric Russell 2012/02/09 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 5,567 reads

show users in NT Groups

List users in NT Groups  Read more...
By Mani Singh 2008/07/29 | Source: SQLServerCentral.com | Category: administrator
Rating: |  Discuss |   Briefcase | 1,189 reads
   Items 1 to 2 of 2   
 
Tags
administration (2)    
administrator (1)    
login information (1)    
roles (1)    
security (1)    
server_principals (1)    
sysadmin (1)    
users (1)