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
 General SQL Server Forums
 New to SQL Server Administration
 sys.database_role_members equialant table

Author  Topic 

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2010-02-26 : 03:12:59
Hi
what are the equilant tables in sql server 2000 for the below tables?
my intension is to find the custom database roles of each user in a database. thanks in advance.

sys.database_role_members
sys.database_principals

Arnav
Even you learn 1%, Learn it with 100% confidence.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-02-26 : 03:43:38
This link should help:
http://msdn.microsoft.com/en-us/library/ms187997.aspx


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -