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 - 2005-06-27 : 08:28:15
|
Ramesh writes "How do I change a collation property of the database as well as collation property of all fields in all the tables of the same database.DB Server - SQL Server 2000Operating System - Windows XP" |
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-27 : 08:45:24
|
The first part is done winth the collate statement in ALTER DATABASE. The second part is done with the collate statement of the ALTER TABLE yourTable ALTER COLUMN yourColumn command.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me though the forum. |
|
|
|
|
|