Find the collations on Database.

vishalneeraj-24503
Posted by vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 207
Below query will return SQL_Latin1_General_CP1_CI_AS or SQL_Latin1_General_CP1_CS_AS (case-sensitive or case-insensitive) on any particular Database.
Select databasepropertyex('YOUR_DB_NAME','collation')

Comments or Responses

Login to post response