how to find out the collation in sql 7?

hi in sql 2000 it is posible to see it in the gui but in sql 7 you cannot see it

how can i know what is the sql collation in the server and in the databases?

thk

There's no such thing as "collation" in MSSQL 7 - it was first introduced in MSSQL 2000. In your case, there's only a codepage.