Written by:R Teachout
6/27/2008 10:06 PM

use [yourdatabasename]
exec sp_change_users_login 'Report'

Will Output Something like:
user1 0x68940EDA46DDD44E9E25F834E4839F74
bsmith 0x37D7D1FFAC865F44AB99CABFA92E5932
jdoe 0xD12465F809AD2940AAFBB938F0270A9C
webuser 0x7C4538615AFD874E999A528283A5793B

These are the orphaned users.

Enjoy!

TrackbackPrint

Location: BlogsRamblings, Scriptlets, and more!MSSQL Scriptlets

Your name:
Title:
Comment:
Security Code Enter the code shown above in the box below
Add Comment   Cancel