sysusers System Table - SQL Server 2000

Contains one row for each Microsoft® Windows user, Windows group, Microsoft SQL Server™ user, or SQL Server role in the database.

Column nameData typeDescription
uidsmallintUser ID, unique in this database. 1 is the database owner.
statussmallintFor internal use only.
namesysnameUsername or group name, unique in this database.
sidvarbinary(85)Security identifier for this entry.
rolesvarbinary(2048)For internal use only.
createdatedatetimeDate the account was added.
updatedatedatetimeDate the account was last changed.
altuidsmallintFor internal use only.
passwordvarbinary(256)For internal use only.
gidsmallintGroup ID to which this user belongs. If uid = gid, this entry defines a group.
hasdbaccessint1, if the account has database access.
isloginint1, if the account is a Windows group, Windows user, or SQL Server user with a login account.
isntnameint1, if the account is a Windows group or Windows user.
isntgroupint1, if the account is a Windows group.
isntuserint1, if the account is a Windows user.
issqluserint1, if the account is a SQL Server user.
isaliasedint1, if the account is aliased to another user.
issqlroleint1, if the account is a SQL Server role.
isapproleint1, if the account is an application role.