How to troubleshoot orphan users in SQL Server databases?

By Bill Graziano on 6 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.

If you like this article you can sign up for our weekly newsletter. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Related Articles

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)

Other Recent Forum Posts

Pivot Table (0 Replies)

Varchar to Numeric help (4 Replies)

Database performance very poor after a moths use (6 Replies)

Repeat records depending field value (2 Replies)

CTE Duplicate Issue (3 Replies)

Dates from weeknumber (0 Replies)

Comparing rows/columns (5 Replies)

Daily Sum, Month To Date, MTD Avg, Prev Month Avg (3 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -