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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy