<div>
no, there is no such equivalent.
</div>


<div>
if so, is principal_id equivalent to uid?
</div>


if so, is principal_id equivalent to uid?

<div>
what about owning_principal_id?
</div>


<div>
if that view is indeed &quot;sysusers&quot;, then in 2000 you would need to presume the &quot;dbo&quot; as &quot;owner&quot; ... ? right?
</div>


if that view is indeed "sysusers", then in 2000 you would need to presume the "dbo" as "owner" ... ? right?

<div>
Im not sure what you're asking...<br />
<br />
general information provided between the 2 is the same. &nbsp;2005+ adds some additional information that was not present in 2000, but same view.
</div>


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.

<div>
Thanks for clarifying.<br />

</div>


<div>
<div class="content wysiwyg-content">
is there a equivalent of the above in SQL 2000?<br />
<br />
thanks
</div>
</div>


is there a equivalent of the above in SQL 2000?

thanks

sys.database_principals in SQL 2000

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.