How can I findout what's my MSSQL server collation?

sql-server collation
OscarRyz picture OscarRyz · Feb 22, 2011 · Viewed 27.9k times · Source

Is there a SQL I can execute to find out?

Answer

RichardTheKiwi picture RichardTheKiwi · Feb 22, 2011

The server default collation:

select serverproperty('collation')

Which is the same as

select databasepropertyex('master','collation')

Check SERVERPROPERTY in Books Online for other information you can get about the server (instance).

Related questions

What does 'COLLATE SQL_Latin1_General_CP1_CI_AS' do?

I have an SQL query to create the database in SQLServer as given below: create database yourdb on ( name = 'yourdb_dat', filename = 'c:\program files\microsoft sql server\mssql.1\mssql\data\yourdbdat.mdf', size = 25mb, maxsize = 1500mb, filegrowth = 10mb ) log …

Read More
SQL Server default character encoding

By default - what is the character encoding set for a database in Microsoft SQL Server? How can I see the current character encoding in SQL Server?

Read More
Cannot Resolve Collation Conflict

I have moved one of our databases (DB1) from SQL Server 2008 to 2012 and when I run the stored procedures I get the following error Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_…

Read More