Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I'm trying to figure out why this query:
SELECT * FROM sys.server_principals WHERE sid = SUSER_SID('Domain\User') OR name = 'Domain\User'
Does not return results for one specific user? At the same time if I remove/comment out WHERE clause I can see that SELECT Domain\User... I've tried to remove and re-add this user under SQL Server > Security > Logins - but it does not help. Can someone indicate what can be wrong here? User name contains non-Latin characters, but no special characters.
Tried your query, worked fine for me.. only thing I can think about for you is try adding N to the 'Domain\User' in your case:
SELECT * FROM sys.server_principals WHERE sid = SUSER_SID(N'Domain\User') OR name = N'Domain\User'
