Capture SQL Logins

• Wesley Brown

  SSChampion

  Points: 12045

  More actions

  September 29, 2007 at 1:19 am

  #198415

  Comments posted to this topic are about the item Capture SQL Logins

• pankaj.baluni

  Ten Centuries

  Points: 1014

  More actions

  October 5, 2009 at 4:16 am

  #1061615

  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.

  Rgds,
  Pankaj

• Silverfox

  SSC-Insane

  Points: 23150

  More actions

  October 5, 2009 at 4:38 am

  #1061626

  pankaj.baluni (10/5/2009)

  ---

  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.

  sysxlogins is sql 2000 only, try syslogins

  --------------------------------------------------------------------------------------
  [highlight]Recommended Articles on How to help us help you and[/highlight]
  [highlight]solve commonly asked questions[/highlight]

  Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
  Managing Transaction Logs by Gail Shaw[/url]
  How to post Performance problems by Gail Shaw[/url]
  Help, my database is corrupt. Now what? by Gail Shaw[/url]