Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
priyaram
Yak Posting Veteran
82 Posts |
 Posted - 2007-01-25 : 16:02:59
|
| what is the status column value spcify in sysusers table.because in our job selecting a row whose status = 2.I am new DBA to this project, and this code were written by previous DBA.Thanks in Advance |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-25 : 16:05:57
|
quote:
sysusersContains one row for each Microsoft® Windows user, Windows group, Microsoft SQL Server™ user, or SQL Server role in the database.Column name Data type Description uid smallint User ID, unique in this database. 1 is the database owner. status smallint For internal use only.name sysname Username or group name, unique in this database. sid varbinary(85) Security identifier for this entry. roles varbinary(2048) For internal use only. createdate datetime Date the account was added. updatedate datetime Date the account was last changed. altuid smallint For internal use only. password varbinary(256) For internal use only. gid smallint Group ID to which this user belongs. If uid = gid, this entry defines a group. environ varchar(255) Reserved. hasdbaccess int 1, if the account has database access. islogin int 1, if the account is a Windows group, Windows user, or SQL Server user with a login account. isntname int 1, if the account is a Windows group or Windows user. isntgroup int 1, if the account is a Windows group. isntuser int 1, if the account is a Windows user. issqluser int 1, if the account is a SQL Server user. isaliased int 1, if the account is aliased to another user. issqlrole int 1, if the account is a SQL Server role. isapprole int 1, if the account is an application role.
Peter LarssonHelsingborg, Sweden |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
priyaram
Yak Posting Veteran
82 Posts |
Posted - 2007-01-25 : 16:21:31
|
| Status = It's for internal use only.But our manager is now asking what's the status =2 means.and why the code is selecting only status =2.Is there any specific user assigned to this.Internal use means it's assigned by the database itself |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-25 : 16:24:57
|
| I think there are not many people that knows the real meaning of the status value 2, because it is for Microsoft internal use only.Did not the other DBA document the code?Peter LarssonHelsingborg, Sweden |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2007-01-26 : 07:39:16
|
| Check the code to see what it does if the status is 2, that may give a clue.-------Moo. :) |
|
|
|
joeller
Starting Member
15 Posts |
Posted - 2011-04-27 : 11:34:49
|
| For anyone who still might be interested. Status = 2 in SS2K meant that user was mapped to log in using Sql authentication. In SS2005 this number was changed to 0. Microsoft recommends that you do not use this column as it has been deprecated and will not necessarily be in future version (Though it was still there as of SS2008).E.R. Joell MCDBA |
|
|
|
|
|
|
|
|
sys.sysusers