Sysusers
May 8, 2001Sql 7.0
Is there Tsql to list the roles of all the users(both logged and unlogged)of sql server.
Any help will be appreciated
ADVERTISEMENT
Sys.sysusers
Jan 25, 2007what 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
Sysusers Table...
May 15, 2000Has anyone else ever restored a database and noticed that any users added into the sysusers table do not show up on the main database GUI under the general tab (i.e., the number of users for that database will equal zero)?
However,a quick look into the sysusers table will show that they are in fact there.
It's very strange.
Any ideas?
Sysusers Table
Sep 21, 2000Does any one know the meaning of "status" column in the sysusers table?
I found out in one of my database the status has three different values: 0, 2, 14, what this value means? Thanks.
Yu
Sysusers Table
May 7, 2007Hi,
In SQL Server, if I active the application role, can all the public user still read the sysusers table even though the application role does not select the sysusers as read permission?
Thanks.
INFORMATION_SCHEMA Login In SysUsers?
Dec 26, 2001Hiya,
I'm trying to run reports, some of which have UserEntered as a criteria. So I'm filling up a list with (SELECT * FROM SysUsers WHERE IsLogin = 1), which is also pulling up INFORMATION_SCHEMA as a login. I'm not really sure why this would be an islogin = 1 or issqluser = 1. Is this a server default login,and if yes,why, and what can I do about it?
Thanks,
Sarah
Replicate Syslogins & Sysusers
Oct 22, 1999Is it possible to have a two way replication of the Logins and Users between two servers? What we have is two SQL 7.0 servers, for an CRM package. They use the CRM replication program to move data back and forth. However, we need to keep the logins and passwords between the two machines ther same. Any thoughts on how to do this?
View 1 Replies View RelatedStatus Field In The Sysusers Table
May 2, 2006Dear All
Within the sysusers table there is a field named status... All the users has this field set to 2. However there is a particular user and the status for this user is set to 14. Does anyone knows what this means... i.e. why the status field is not set to 2 as it is for the other users?
Regards
Sandro
Sysusers Messed Up After Moving Db From One Server To Naother?
Jan 17, 2000Hello:
We are running an application on mssql 6.5, sp 4.
As the data for the application is growing by leaps and bounds, we were shortly going to run out of disk space on one and decided to move production to a new, larger box.
I took a full backup of the current production database nad loaded it onto the new server with no problems except one.
When users tried to log in, there were problems. Apparently the passwords for users were switched with other users or somehow the sysusers data got reversed. THe logins, or the data from msyslogins, looked fine.
I don't understand how a full backup and then a restore would have any effect on the sysusers data.
Has any one experienced this before? Other than bcp out the data from sysusers and bcp'ing the data after the restore, is there any thing else I can do?
Does any one have a script tp offload sysusers data?
Any help which can be provided would be appreciated. THanks.
David Spaisman
Sysusers Table Status Cloumn Problem In SQL2005
Mar 15, 2007
Hi everyone
I have a problem about sysusers table in sql2005.
if you run the query in SQL2000
select * from sysusers where status = 2
and you can see the users which are created as sqlauthentication.
But in sql2005 status column equals 0 for sql authenticated users.
Is this a bug or the sturucture of the sysusers table is changed???
And how can i query the sql authenticated users in sql2005.
thanks