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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2005-11-01 : 06:08:26
|
| is it possible after a database has been created to change its Collection name? if yes hten how?thanks i nadvancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-11-01 : 06:44:49
|
what's a collection name? never heard of it...Go with the flow & have fun! Else fight the flow  |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-01 : 06:47:46
|
| Collation name, maybe?Yes, but you'll probably have to recreate all the tables and "migrate" the data from the old to the new.Kristen |
|
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2005-11-01 : 08:14:06
|
| yep Collation name sorrywhen can i read this?Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-01 : 10:31:57
|
| You mean this:SELECT SERVERPROPERTY( 'Collation' )??Kristen |
|
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2005-11-12 : 14:01:15
|
| yes but why the resllt i recive is binary?Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-11-12 : 22:00:01
|
Someone setup the server as a binary collation/sort order.  Is it CP437_BIN? How old is this SQL Server installation? Back in the 6.5 days, it was slightly faster to use the binary sort order. Unfortunately, several companies have never switched off this, which can cause some integration issues with many third-party applications.To change the collation on a server, lookup "changing collation settings" and "changing collations" on the index tab of Books Online. Books Online is included free with SQL Server.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
change the collection name of a db