To check for orphaned users in a database

Question

To check for orphaned users in a database

RGP

SSCarpal Tunnel

Points: 4381
More actions
July 21, 2008 at 10:51 pm

#210249

Comments posted to this topic are about the item To check for orphaned users in a database

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

cweekes Valued Member Points: 72 More actions · Answer 1

There is also a built-in stored procedure called 'sp_change_users_login'. It works on the current database and only for sql accounts, not windows logins. It can be used to list orphaned users and to reconnect them. I am not sure if it is available before SQL 2005.

don.schaeffer Ten Centuries Points: 1245 More actions · Answer 2

Very useful script. It would be nice if it didn't consider users created from certificates as orphaned.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 3

akljfhnlaflkj

SSC Guru

Points: 76202

May 2, 2016 at 1:16 pm

#1876028

Thanks for the script.

To check for orphaned users in a database

Cookies on SQLServerCentral