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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Collation

Author  Topic 

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2006-09-22 : 01:05:12
Dear All,

I have instaled the sql server in default collation .i have restored 17 db's. But I need to change the collation as SQl_1.xCompact_CP850_CI_AS. is it possible ..? if yes please say me the steps

Thanks and regards
krishnakumar.C

Kristen
Test

22859 Posts

Posted - 2006-09-22 : 02:20:51
This may help:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Collate,Collation

Kristen
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-09-22 : 02:23:39
Yes. There are some scripts here.
Look at this topic of how to change collation
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2006-09-22 : 02:57:06
Thanks. I done it. But it taking long time to process
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-09-23 : 03:52:53
"But it taking long time to process"

Is that the bit where I said, in one of those links, "I did it once and never again, next time I will reinstall?"

Maybe you are only going to do it once that way too!

Kristen
Go to Top of Page
   

- Advertisement -