Windows users mapped to SQL Groups

• Sanz

  Hall of Fame

  Points: 3412

  More actions

  April 16, 2009 at 7:05 am

  #130126

  In my Sql Server 2005 I have few groups (eg:SQLAdministrator) that have sysadmin privilege. I need to find out the windows users that are mapped to these groups. Also I need to find out the date when these users were mapped to the groups.

  I am looking for some kind of script that can give me this information.

  Thanx in Advance !

  Sanz

• SA-1

  SSCrazy Eights

  Points: 8113

  More actions

  April 16, 2009 at 7:07 am

  #978782

  This should give you a good starting point

  http://cwashington.netreach.net/depo/view.asp?Index=1119

• Sanz

  Hall of Fame

  Points: 3412

  More actions

  April 16, 2009 at 7:13 am

  #978787

  Thanx for the quick response.

  I was looking for a way to query if from Sql Server.

  Sanz

• SA-1

  SSCrazy Eights

  Points: 8113

  More actions

  April 16, 2009 at 7:18 am

  #978793

  I think you will need a linked connection setup

  http://www.sqlservercentral.com/Forums/Topic695128-359-1.aspx

• Sanz

  Hall of Fame

  Points: 3412

  More actions

  April 16, 2009 at 7:36 am

  #978812

  Is there any system table/tables that contain this information ??

  Sanz

• SA-1

  SSCrazy Eights

  Points: 8113

  More actions

  April 16, 2009 at 7:44 am

  #978824

  Not by default. Although, based on your requirements it would be possible to script something to pull this information periodically in a database.