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 - 2005-03-23 : 07:24:00
|
| Dragan Hanc writes "Is it possible to change the case sensitivity after the installation of SQL. In opposed to having to reinstall?Thanks" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-03-23 : 07:30:53
|
look up "collate" and "collation" in SQL server help = Books online = BOLGo with the flow & have fun! Else fight the flow  |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-03-23 : 08:35:19
|
| You will need to rebuild master to do it - may as well re-install.You can change a database but then will have to change the existing tables and that would leave tempdb and the database with different collations which will cause problems with temp tables.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Case sensitivity