How can we remove Orphan User Instead of fixing it?
Posted by Jugal Shah on December 22, 2010
You can list of the list of orphan user by executing below query.
EXEC sp_change_users_login 'Report'
To remove/Delete Orphan User you can use below query.
exec sp_revokedbaccess 'DJ'
18.520469
73.856621
Like this:
Be the first to like this post.
This entry was posted on December 22, 2010 at 6:40 am and is filed under Database, SQL Server, SQL Server 2008, SQL Server 2008 R2.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
