• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 340
  • Last Modified:

What system table is the user-role relationship being stored in SQL Server 2005?

On which system table in SQL Server 2005 can I find the link between the user and database role.   It used to be in sysusers using uid and gid using the old version of sql server.
0
cvaliulis
Asked:
cvaliulis
1 Solution
 
rboyd56Commented:
The sys.sysuers view has the same information as sysusers in SQL Server 2000

You can also get similar information from sys.database_principals
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now