Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-28 : 08:36:05
|
| Ivan writes "I restored a database from a server with different default collaction.How can i change the collation of any column of my database tables to new server default collaction with a simple command?Thank you" |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-05-28 : 16:23:53
|
| Use ALTER TABLE to change the collation setting of a specific column.ALTER TABLE table { [ ALTER COLUMN column_name { new_data_type [ ( precision [ , scale ] ) ] [ COLLATE < collation_name > ] [ NULL | NOT NULL ] | {ADD | DROP } ROWGUIDCOL } ] The collation property is set when the database is created. In a restore operation, you are stuck with the collation the database had at the time of backup. |
 |
|
|
|
|
|
sql collation in sqlserver 2000