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 - 2004-07-02 : 09:09:07
|
| rajesh writes "HII am Having SQL server 2000 installed,server default collation is CASE-INSENSITIVE.How can i change it to Case-Sensitive without reinstalling SQL server 2000.Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data RegardsRajesh" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-07-02 : 11:50:33
|
| I you just built the box, you'd be better of rebuilding it...I can't begin to imagine the headaches....Brett8-) |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-02 : 13:35:11
|
| Can you just create the Database as a CASE SENSITIVE collation instead of the whole server?Kristen |
|
|
|
keithc1
Yak Posting Veteran
88 Posts |
Posted - 2004-07-02 : 20:18:33
|
| I beleive if you need to apply the collation to the tables created with the database you could use.ALTER DATABASE MyDatabase COLLATE French_CI_AS If you just need collation for a table you could with an alter table etcCan also use function to retrive collation names on your server usingSELECT *FROM ::fn_helpcollations()Keithc MCSE MCSA |
|
|
|
kselvia
Aged Yak Warrior
526 Posts |
Posted - 2004-07-02 : 21:17:03
|
| You are going have nightmares with different collations. You can create case sensitive databases but tempdb will be created with the characteristics of model and if tempdb differs from your other databases, selecting from tables joined against tables in your db will fail unless you specify collations for objects. You don't want to go there. I also wonder why you would really want a case sensitive db. You realize that all tables, columns, variables etc. will have to be refernced by exact case. i.e. 'exec MyProc' will fail if your procedure is called Myproc. |
|
|
|
|
|
|
changing collation in SQL server 