SQLTeam.com Logo

Return to How to troubleshoot orphan users in SQL Server databases?

How to troubleshoot orphan users in SQL Server databases?

Written by Bill Graziano on 06 August 2002

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."