MS SQL Error: 21008 SQL-DMO Login already exist.

I can't Delete Login.
MS SQL Error: 21008 SQL-DMO Login  already exist.
I did not found it in any of my DBs except in master.dbo.sysxlogin but i can t delete (ad hoc query)???

How can I delete and/or clean my sysxlogin table in master db
SilvertreAsked:
Who is Participating?
 
MNelson831Connect With a Mentor Commented:
Try running this in QA while connected to the relevant database:

exec sp_Change_Users_Login Auto_fix,'LOGINNAMEGOESHERE'
0
 
gpompeCommented:
Have you tried with sp_droplogin ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.