How to troubleshoot orphan users in SQL Server databases?

By Bill Graziano on 06 August 2002 | 0 Comments | Tags: Tools

Narayana Vyas Kondreddi submitted "This article explains how orphan users get created, and provides you with troubleshooting information. A bonus stored procedure called ShowOrphanUsers is included, that goes and searches all the databases and generates a complete list of orphan users." Follow the link to How to troubleshoot orphan users in SQL Server databases?...

Discuss this article: 0 Comments so far. Print this Article. This page has been read 6,010 times.

If you like this article you can sign up for our newsletter. We send it out each week that we post a new article. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Email This • Subscribe to this feed • Kick it • Save to del.icio.us • View blog reactions

Debugging Stored Procedures in Visual Studio 2005 (25 June 2007)

Free online SQL Formatter (5 April 2006)

Free tools for SQL Server (2 March 2006)

Software Review: SQLCompare (27 April 2004)

Compare SQL Server databases (2 May 2003)

Foam - FOR XML EXPLICIT Tool (9 August 2002)

Getting the Most Out of SQL Server 2000's Query Analyzer, Part III (7 August 2002)

Working with email addresses in SQL Server! (21 July 2002)