RSS

Change The Server Collation after installation

18 Jan

After you finish installation for SQL server may be you want to change the Server collation or database Collation so leat’s see what will we do if we want to make this :

1- if you want to know what’s your database collation know

SELECT name, collation_name

FROM sys.databases WHERE name = ‘test’   — put your database name here

2- If you want to get a list of all available collations on the server using

SELECT * FROM ::fn_helpcollations()

3- Alter Database Collation

ALTER DATABASE test           — put your database name here

COLLATE Arabic_CI_AS        — replace with whatever collation you need

4- IF you want to know what’s your server collation

SELECT SERVERPROPERTY (‘Collation’)

 
1 Comment

Posted by on January 18, 2012 in Configuration, Configuration

 

One response to “Change The Server Collation after installation

  1. dineshvishe1Dinesh

    June 9, 2013 at 6:55 PM

    Hi,

    Can check for this is best option.above will change only for single database.
    server level collation change needs reinstall of SQL or rebuilding system databases.
    database level collation can be changed by database properties but that doesn’t change collation of objects in database.
    Following link will give you clear Idea.

    http://msdn.microsoft.com/en-us/library/ms179254.aspx

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s