Home Forums Article Discussions Article Discussions by Author Discuss content posted by Timothy Ford Fixing Orphaned Users RE: Fixing Orphaned Users
Antares686
SSC Guru
Points: 125444
More actions
December 4, 2007 at 10:33 am
#757060
This is what I personally use
select 'exec sp_change_users_login ''AUTO_FIX'',''' + [name] + '''', * from sysusers where status != 0 and uid > 2
it builds a string for each account, then I take and run the resultset in another window.