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

sys.database_principals in SQL 2000

is there a equivalent of the above in SQL 2000?

thanks
0
anushahanna
Asked:
anushahanna
  • 5
  • 3
  • 2
3 Solutions
 
chapmandewCommented:
sysusers
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
no, there is no such equivalent.
0
 
chapmandewCommented:
sure there is...sysusers.
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
anushahannaAuthor Commented:
if so, is principal_id equivalent to uid?
0
 
chapmandewCommented:
yup
0
 
anushahannaAuthor Commented:
what about owning_principal_id?
0
 
chapmandewCommented:
doesn't appear to be a 1:1 matchup.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
if that view is indeed "sysusers", then in 2000 you would need to presume the "dbo" as "owner" ... ? right?
0
 
chapmandewCommented:
Im not sure what you're asking...

general information provided between the 2 is the same.  2005+ adds some additional information that was not present in 2000, but same view.
0
 
anushahannaAuthor Commented:
Thanks for clarifying.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 5
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now