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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 user control problem

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-03-14 : 16:13:48
pang writes "Dear SQL Team,

I have one problem with SQL server which I cannot find the solution. so I would like you to help and give some idea to me.
My problem is that I can not find the table that store User ID,User name, Group name/Role, Default schema. I strongly hope that I will get an answer from your team.

I am waiting for your kind reply.

Sincerely,

Pang"

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-03-14 : 16:39:03
Check :
Select * from sysusers

and check the Books OnLine on this, as well
Go to Top of Page
   

- Advertisement -