Solved

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

Posted on 2006-10-19
2
1,989 Views
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
0
Comment
Question by:Silvertre
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 9

Expert Comment

by:gpompe
ID: 17769189
Have you tried with sp_droplogin ?
0
 
LVL 15

Accepted Solution

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

exec sp_Change_Users_Login Auto_fix,'LOGINNAMEGOESHERE'
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Query Task 11 44
Need help with convert Informix SQL SELECT statement to Microsoft SQL 1 26
SQL Instance service gone? 5 39
Need SSIS project 2 30
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

726 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