You can determine MSSQL Server collation using the SQL Server Management Studio. Open the MSSQL Server Management Studio, right click on the database instance. Click on Properties.
You can find the collation version from the General and Options page.
