Thanks for that, worked perfectly.

This doesn't appear to work correctly.

I'm basically after a list of users that have been created under SECURITY|LOGINS and what Databases they have access to and what permissions.

any ideas?

If I alter the sp_defaultlanguage from US_english to British and run against all databases will this work?