Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

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

Tags:

sql-server

collation

Is there a SQL I can execute to find out?

like image 420
OscarRyz Avatar asked Feb 22 '11 00:02

OscarRyz

1 Answers

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).

like image 91
RichardTheKiwi Avatar answered Oct 23 '22 17:10

RichardTheKiwi
Sign in to Comment

Related questions

How to insert null in datetime type column in sql server
Replace Multiple Strings in SQL Query
Casting Eval("bitValue") as Bool
Update multiple records in SQL
A cursor with the name ... already exists - SQL Server 2008
How does Entity Framework generate a GUID for a primary key value?
Is Guid the best identity datatype for Databases?
Accounting and Database design, storing debit and credit amount
How to insert multiple select statements into a temp table
How to use TAB as column separator in SQLCMD
Creating procedure inside IF section
Most efficient method for adding leading 0's to an int in sql
Rows showing as #DELETED
What this query does to create comma delimited list SQL Server?
Iterate through a list of strings In SQL Server?
Convert SQL Server Date to mm-yyyy
How to find out user name and machine name to access to SQL server
How to validate SQL Server traffic is encrypted?
Is there a way to get a boolean without casting in SQL Server?
How can I remove empty lines in SQL Server Management Studio (SSMS)?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!