December 10, 2003 at 4:30 am
Maybe it's just SQL 2k, but I don't have a syslogins table, I have a sysxlogins table in the master db, and it doesn't have a column isntname, the sysusers table does. What am I missing here?
Sloan
If you can't do it in SQL, get a bigger hammer!
Sloan
If you can't do it in SQL, get a bigger hammer!
December 10, 2003 at 4:40 am
if you take a look at design of syslogins you cannot see this column .is the isntname column hidden?
December 10, 2003 at 4:51 am
I can see it in QA when firing a SELECT * FROM master..syslogins and it is explicitely explained in BOL
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
December 10, 2003 at 9:08 am
Syslogins is a view in the Master database that selects from sysxlogins table. Curiously, BOL refers to syslogins as a system table.
Greg
December 11, 2003 at 5:17 am
syslogins used to be the table. I think it became a view on the sysxlogins table for SQL 2000, but maybe SQL 7.
Larry Ansley
Atlanta, GA
Larry Ansley
Atlanta, GA
December 12, 2003 at 10:24 pm
Thanks Frank .I mean Enterprise Manager .
December 13, 2003 at 12:31 pm
Actually you don't see the column in the table, because there is not such a column. Look at the view definition and you'll see that it is a bitwise excerpt (hopefully I can say so) of the xstatus column.
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply