1. sp_helpdb yourdatabase, and look for collation setting. or
select databasepropertyex('yourdatabase', 'collation')
2. run query
select
collationproperty('SQL_Latin1_General_CP1_CI_AS', 'LCID') --The Windows LCID of the collation.
,collationproperty('SQL_Latin1_General_CP1_CI_AS', 'CODEPAGE') --The nonUnicode code page
replace the SQL_Latin1_General_CP1_CI_AS will the output of step1.
