Capture SQL Logins

SQLServerCentral is supported by Red Gate Software Ltd.

Home Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Wesley Brown » Capture SQL Logins

Capture SQL Logins

Rate Topic

Display Mode

Topic Options

Author

Message

Wesley Brown

Posted Saturday, September 29, 2007 1:19 AM

Mr or Mrs. 500

Group: Moderators
Last Login: Tuesday, November 17, 2009 12:51 PM
Points: 577, Visits: 119

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

http://www.nitrosphere.net
http://www.cactuss.org
http://www.salssa.org

Post #404319

pankaj.baluni

Posted Monday, October 05, 2009 4:16 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, November 18, 2009 2:58 AM
Points: 71, Visits: 38

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

Post #797749

Silverfox

Posted Monday, October 05, 2009 4:38 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:18 AM
Points: 2,595, Visits: 988

pankaj.baluni (10/5/2009)

sysxlogins is sql 2000 only, try syslogins

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

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

Post #797766

« Prev Topic | Next Topic »

Permissions