InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 22:04:40 GMT20http://www.sqlservercentral.com/Forums/Topic698368-146-1.aspxNot by default. Although, based on your requirements it would be possible to script something to pull this information periodically in a database.Thu, 16 Apr 2009 07:44:11 GMTSA-1http://www.sqlservercentral.com/Forums/Topic698368-146-1.aspxIs there any system table/tables that contain this information ??Thu, 16 Apr 2009 07:36:22 GMTSanzhttp://www.sqlservercentral.com/Forums/Topic698368-146-1.aspxI think you will need a linked connection setup[url]http://www.sqlservercentral.com/Forums/Topic695128-359-1.aspx[/url]Thu, 16 Apr 2009 07:18:19 GMTSA-1http://www.sqlservercentral.com/Forums/Topic698368-146-1.aspxThanx for the quick response.I was looking for a way to query if from Sql Server.Thu, 16 Apr 2009 07:13:54 GMTSanzhttp://www.sqlservercentral.com/Forums/Topic698368-146-1.aspxThis should give you a good starting point[url]http://cwashington.netreach.net/depo/view.asp?Index=1119[/url]Thu, 16 Apr 2009 07:07:41 GMTSA-1http://www.sqlservercentral.com/Forums/Topic698368-146-1.aspxIn 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 !Thu, 16 Apr 2009 07:05:13 GMTSanz