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 - 2002-04-26 : 10:59:28
|
| Margaret writes "We are thinking about changing our collation(code page) from 850 to 1252. It is a sql server 2000 enviroment. I am trying to weight the options of just changing the database vs changing the installation(master). What are the trade off's and risks in just changing the database to 1252 and not the master?" |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-04-26 : 11:37:36
|
| If you change collation at the database level, and if you have a lot of code that uses tempdb, that code will likely break. The reason is that collation of tempdb is the same as collation in master... Of course you can fix everything by using COLLATE function every time you use tempdb, but that gets to be a major pain.---------------Strong SQL Developer wanted in the Boston area. Please e-mail if interested. |
 |
|
|
|
|
|
Collation