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.

How to Find Index Size / Usage (mb)

I'm trying to establish the mb usage of a series of nonclustered indexes, I'm used to using the manage indexes GUI in 6.5, and showcontig doesn't quite give me what I want, any suggestions?Have you tried sp_spaceused <table_name> yet?|||That's a great help thanks, is it possible to drill down into the 3 indexes to see how the usage is split?