Solved

uid to principal_id

Posted on 2010-08-27
3
616 Views
Last Modified: 2012-06-21
In the older version, user was also some sort of 'uid'
sysusers.uid
sysmembers.memberuid

is it being change to principal_id in the new versions?
sys.schemas.principal_id

thanks
0
Comment
Question by:anushahanna
  • 2
3 Comments
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
ID: 33542799
Yes, it is..
To confirm that, just run the query below:

select *, SUSER_name(principal_id), USER_name(principal_id)  
from sys.schemas
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33543034
Thanks for confirming that.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33543126
Welcome..
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSIS Conditional Split 7 31
Count with a subquery showing details 10 40
TSQL query to generate xml 4 31
Sql server, import complete table, using vb.net 9 32
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now