SQLServerCentral / Discuss Content Posted by Wesley Brown / Article Discussions / Article Discussions by Author / Capture SQL Logins / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 24 May 2012 12:06:39 GMT20RE: Capture SQL Loginshttp://www.sqlservercentral.com/Forums/Topic404319-195-1.aspx[quote][b]pankaj.baluni (10/5/2009)[/b][hr]Hello Wesley,I'm using SQL 2005 and didn't find ' master.dbo.sysxlogins'. please suggest how to go about it.in SQL 2000 we do see this table. Thanks in advance.Also, please share a modified query for SQL 2005 for this same purpose.[/quote]sysxlogins is sql 2000 only, try sysloginsMon, 05 Oct 2009 04:38:39 GMTSilverfoxRE: Capture SQL Loginshttp://www.sqlservercentral.com/Forums/Topic404319-195-1.aspxHello Wesley,I'm using SQL 2005 and didn't find ' master.dbo.sysxlogins'. please suggest how to go about it.in SQL 2000 we do see this table. Thanks in advance.Also, please share a modified query for SQL 2005 for this same purpose.Mon, 05 Oct 2009 04:16:12 GMTpankaj.baluniCapture SQL Loginshttp://www.sqlservercentral.com/Forums/Topic404319-195-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Miscellaneous/31159/">Capture SQL Logins</A>[/B]Sat, 29 Sep 2007 01:19:22 GMTWesley Brown