September 29, 2007 at 1:19 am
Comments posted to this topic are about the item Capture SQL Logins
October 5, 2009 at 4:16 am
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
October 5, 2009 at 4:38 am
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]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply