Solved

schema request

Posted on 2011-02-18
4
920 Views
Last Modified: 2013-11-05
I dont have any 2000 or 2005 instance of sql server to identify what I am after.

I want the table schema for (2000) master..sysxlogins and (2005) sys.sql_logins

Can anyone send the 2 schemas to me?
0
Comment
Question by:pma111
  • 2
4 Comments
 
LVL 7

Accepted Solution

by:
mkobrin earned 65 total points
ID: 34925102
TABLE [sysxlogins]

      [srvid] [smallint] NULL ,
      [sid] [varbinary] (85) NULL ,
      [xstatus] [smallint] NOT NULL ,
      [xdate1] [datetime] NOT NULL ,
      [xdate2] [datetime] NOT NULL ,
      [name] [sysname] NULL ,
      [password] [varbinary] (256) NULL ,
      [dbid] [smallint] NOT NULL ,
      [language] [sysname] NULL ,
      [isrpcinmap] AS (convert(smallint,case when ([xstatus] & 32 = 32) then 1 else 0 end)) ,
      [ishqoutmap] AS (convert(smallint,case when ([xstatus] & 64 = 64) then 1 else 0 end)) ,
      [selfoutmap] AS (convert(smallint,case when ([xstatus] & 192 = 192) then 1 else 0 end))

I don't have sys.sql_logins from 2005 with me now.
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 60 total points
ID: 34925773
sys.sql_logins is not a table it is a system VIEW.  Here is the definition from SQL Server BOL:
http://msdn.microsoft.com/en-us/library/ms174355(SQL.90).aspx


0
 
LVL 3

Author Comment

by:pma111
ID: 34926062
By "Inherits from sys.server_principals" does that mean if you

ran select * from sys.sql_logins youd get all the fields from that view/table as well

Basically I have an extract of select * from sys.sql_logins, minus the column names, its the column names I am trying to find so I know what row of data represents what...
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 34926546
>>select * from sys.sql_logins youd get all the fields from that view/table as well<<
Yes.  In other words you need to click on the link in the article (that is http://msdn.microsoft.com/en-us/library/ms188786(v=SQL.90).aspx) and that will show you all the columns that are derived from the sys.server_principals.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question