July 21, 2008 at 10:51 pm
Comments posted to this topic are about the item To check for orphaned users in a database
September 23, 2008 at 7:08 am
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.
September 24, 2008 at 10:31 am
Very useful script. It would be nice if it didn't consider users created from certificates as orphaned.
May 2, 2016 at 1:16 pm
Thanks for the script.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply