Thanks Folks, for all the good suggestions and corrections, I will check out the link and rewrite the script to cater for the scenarios mentioned and post again here for...

I initially started off doing SQL Server work after finishing from Uni for a few months, loved it but then was whisked away and told to attend to problem applications,...

SSC-Enthusiastic, I like the script you posted, it works the same, and importantly I do not have to user a cursor and create a temp table to get the information...

The boxes '????' representing spaces/tab, are part of the query being copied over, get rid of them and your query will execute OK.

For instance, "????SELECT role_principal_id, member_principal_id FROM sys.database_role_members"

Delete...