I've been using this site for a while and this is the first time I've had to ask a question, but just wanted to say "Thank You" to everyone who has helped me in the past (without knowing they did so).
First things first.. I am trying to delete a user. To locate the user, I execute the following:
USE [MASTER] SELECT SUSER_SID('henryhr')
When I try this:
SELECT * FROM sys.database_principals WHERE sid = 0x01050000000000051500000084BC6CEC253AF11EEEFBBA6A240F0034
It returns 0 rows. If I try:
USE [MASTER] DROP LOGIN henryhr
Msg 15151, Level 16, State 1, Line 1
Cannot drop the login 'henryhr', because it does not exist or you do not have permission.
I have tried creating another user and going through the same process and it works just fine. Any idea how to delete this?