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 |
|
rezwan_marshall
Starting Member
1 Post |
 Posted - 2008-09-25 : 09:45:53
|
| Does anybody know about any tool that can change database,table and column level collation?and likn to download ?rezwan |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-25 : 09:49:16
|
| You can change collation of table & column by means of ALTER TABLE & ALTER COLUMN statement using COLLATE clause. |
 |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-10-01 : 11:22:22
|
| For user database Alter statement works. You cannot use Alter for system databases. Sp_detach user databases and rebuild master with desired collation and attach user databases. |
|
|
|
|
|
|
collation changint tool