list default langauge of all users

[voxinforma]

I have a database with about 200 user accounts. About a dozen users have the default language set to Spanish, the rest are English. I need to find out which users are set to Spanish. How do I do this without having to look through each user login account individually?

 

[rt63]

check out in the system table syslogins (there is a field called language)

RT

 

[osjohnm]

try the following:

run against the master database...

select name, language from syslogins
where language = 'spanish'

John