(The easy question first <s>)

You can find out what character set and sort order the server is running using the sp_helpsort system stored procedure. From the ISQL/W or Query Analyzer (depending on which version of SQL Server you're running) issue:

EXECUTE sp_helpsort

-Mike