collation

hi,
how to find out what collation my sql server is using? Thanks.Select SERVERPROPERTY('Collation')
HTH, Jens Suessmeyer.|||Thanks for the help.
How about mydb's collation? I'm use msde, can' t view it throguth EM.
<jsuessmeyer@.web.de> wrote in message
news:1126627303.347700.111450@.f14g2000cwb.googlegroups.com...
> Select SERVERPROPERTY('Collation')
> HTH, Jens Suessmeyer.
>|||make a guess :-)
SELECT DATABASEPROPERTYEX('Northwind', 'Collation')
HTH, Jens Suessmeyer.|||This is one of the properties listed in
EXEC sp_helpdb

> Thanks for the help.
> How about mydb's collation? I'm use msde, can' t view it throguth EM.