Lester Policarpio
SSCertifiable
Points: 7109
More actions
October 11, 2007 at 2:03 am
#62172
Guys just wanna ask if anyone of you know how to display all the orphaned users per database? Something like this...
DBName DBUser Status
Orphaned
I need a simplified form of SQL Statement to gather this information. Thanks in advance....
"-=Still Learning=-"
Andras Belokosztolszki
SSC-Insane
Points: 22031
October 11, 2007 at 3:08 am
#741102
EXEC sp_MSForeachDB "use ? Exec sp_change_users_login 'Report'"
Regards,
Andras
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply