| Author |
Topic |
|
the1gadget
Yak Posting Veteran
55 Posts |
 Posted - 2005-09-21 : 11:05:11
|
| Hi AllIs it posible to change the server collation after it has been installed?-- David |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2005-09-21 : 11:56:55
|
| NO. As far as i know this is not possible. Atleast there is no easy way to do it....------------------------I think, therefore I am - Rene Descartes |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-21 : 15:02:45
|
| Definitely no easy way to do it. I did it once and vowed never again. Reinstall is much easier IMHO. Make sure all databases are Backed Up ("just in case"), detach all the databases, reinstall, re-attach (or if that fails Restore).Kristen |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-09-21 : 15:14:55
|
| What good are the backups? He won't be able to restore them after the reinstallThey'll have to migrate all the data out, script the database, reinstall, then reload...Unless I'm mistakenBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-21 : 15:50:58
|
"What good are the backups"I was assuming that the User DBs had explicit COLLATE defined per-column. But maybe not ...  Kristen |
|
|
|
the1gadget
Yak Posting Veteran
55 Posts |
Posted - 2005-09-22 : 06:04:54
|
| Hi AllThanks.As it is a development server and there is no real working database so I will be doing a reinstall.I will then have all the usual fun of restoring a DB from a different server.-- David |
|
|
|
homebrew
Posting Yak Master
114 Posts |
Posted - 2005-09-23 : 14:20:42
|
| Just FYI .... Each Database can have it's own collation, so even if your Server is Collation_A, you can create databases with Collation_B on that server. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-23 : 14:38:33
|
... and Columns with Collation_C  Kristen |
|
|
|
testsql
Starting Member
1 Post |
Posted - 2005-09-23 : 18:36:56
|
| test |
|
|
|
wagan
Starting Member
3 Posts |
Posted - 2006-08-31 : 08:23:18
|
| Is ok to change the collation name of the tempdb? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-31 : 12:30:01
|
quote:
Originally posted by wagan
Is ok to change the collation name of the tempdb?
Why would you want to do this?Tara Kizer |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-09-01 : 17:05:18
|
| wagan, Welcome to SQL Team!Reinstall your server. I realise that is seemingly a simplistic answer. It avoids loads of other collateral damage over the next few months. If you haven't been in this situation before its hard to gauge what the impact is, so I can only suggest you take the advice of an Old Grey Haired Bloke! If it turns out that you need a different collation for your server my advice is: Cut&Run, and reinstall.Kristen |
|
|
|
CorpDirect
Yak Posting Veteran
92 Posts |
Posted - 2006-09-20 : 10:03:21
|
| Hi folks,I posted a topic asking about migrating databases to a new collation using DTS (though other suggestions are welcome!) here:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72229[/url]Since the topic is somewhat related to this one, I hope those of you who responded here will be able to offer suggestions.Thanks for any help!Daniel |
|
|
|
|
Change Collation for a server