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

Posted on 2006-10-19
Medium Priority
Last Modified: 2009-07-29
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
Question by:Silvertre

Expert Comment

ID: 17769189
Have you tried with sp_droplogin ?
LVL 15

Accepted Solution

MNelson831 earned 1000 total points
ID: 17769249
Try running this in QA while connected to the relevant database:

exec sp_Change_Users_Login Auto_fix,'LOGINNAMEGOESHERE'

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

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.

Join & Write a Comment

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how the fundamental information of how to create a table.

621 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