Solved

uid to principal_id

Posted on 2010-08-27
3
602 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
Comment Utility
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
Comment Utility
Thanks for confirming that.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
Comment Utility
Welcome..
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

771 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

10 Experts available now in Live!

Get 1:1 Help Now