|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
sql server collationhello
can somebody please tell me what selection i have to make in order to have a collation "SQL_Latin1_General_CP1_CI_AS" as a default servercollation while installing SQL server? someone installed our produciton server and "forgot" what he selected while installing the server. Now i have to copy some DBs from that machine to an other one but some selects do not work any more, of course ... _tia udo found it.
its: "Dict, case insesitiv" without any other language extention ... try and error polder_udo schrieb: Show quoteHide quote > hello > > can somebody please tell me what selection i have to make in order to > have a collation "SQL_Latin1_General_CP1_CI_AS" as a default > servercollation while installing SQL server? > > someone installed our produciton server and "forgot" what he selected > while installing the server. Now i have to copy some DBs from that > machine to an other one but some selects do not work any more, of > course ... > > _tia udo  
Other interesting topics
Assigning a row number to each row (for pagination and browse)
Performance and Index rename SELECT * Why does this query work but that one does not Update for table without Primary key SP for poll table Evaluate() or similar function in sql server 2000 or sql server 2005 ? SQL2K Question Bookmark Lookups... select * |
|||||||||||||||||||||||
