SQl 2008 change collation of all columns

Question

Post reply

SQl 2008 change collation of all columns

mssqlsrv

SSCrazy

Points: 2375
More actions
September 2, 2012 at 10:24 pm

#280680

HI,
How can I change collation of all columns in sql 2008.
I am getting error for keys.
Is there any script to drop keys and change collation and then again generate the keys
which was dropped earlier.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

arunkumarco SSC Enthusiast Points: 112 More actions · Answer 1

arunkumarco

SSC Enthusiast

Points: 112

September 3, 2012 at 5:57 am

#1532929

What error code are you getting?

-Arun

SteveEClarke SSCertifiable Points: 5161 More actions · Answer 2

When you first install sql you specify the collation to use as the default.

you are able to create views and at that time specify the translated collation to use if you desire.

Where is the message appearing from ? is it in the application or when you are writing script ?

________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP

Please don't trust me, test the solutions I give you before using them.

deepzzzz SSCrazy Points: 2890 More actions · Answer 3

While Creating database you can specify the collation type you want.

By default, it will be SQL SERVER DEFAULT SQL_Latin1_General_CP1_CI_AS

If you are getting error, you can specify as column name COLLATE collation type

Thanks

Ant-Green SSC Guru Points: 113507 More actions · Answer 4

deepzzzz (9/3/2012)
While Creating database you can specify the collation type you want.
By default, it will be SQL SERVER DEFAULT SQL_Latin1_General_CP1_CI_AS
If you are getting error, you can specify as column name COLLATE collation type

It will be the collation of whatever the model DB is, which is not nessesarily SQL_Latin1_General_CP1_CI_AS, it will depend what collation the server was installed with or if the user has changed the collation of model.

Ant-Green SSC Guru Points: 113507 More actions · Answer 5

mssqlsrv (9/2/2012)
HI,
How can I change collation of all columns in sql 2008.
I am getting error for keys.
Is there any script to drop keys and change collation and then again generate the keys
which was dropped earlier.

This topic should help

http://www.sqlservercentral.com/Forums/Topic820675-146-1.aspx

Comment from Paul Smith-221741 @ 11/20/2009 9:28:51 AM

mssqlsrv SSCrazy Points: 2375 More actions · Answer 6

Thanks for the link Anthony.

I'll try to implement the steps and will inform you all guys!