Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2056
  • Last Modified:

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
0
Silvertre
Asked:
Silvertre
1 Solution
 
gpompeCommented:
Have you tried with sp_droplogin ?
0
 
MNelson831Commented:
Try running this in QA while connected to the relevant database:

exec sp_Change_Users_Login Auto_fix,'LOGINNAMEGOESHERE'
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now