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 |
|
rgu01
Starting Member
1 Post |
 Posted - 2008-02-27 : 06:01:02
|
| Hi,I'm currently working with a SQLServer instance that uses a case insensitive collation. In this instance we have a number of user databases that are created without COLLATE and hence 'inherits' the same collation as the SQL Server is installed with. I have searched the forum and understand that I need to rebuild the master db in order to change the 'default' collation. However, I do not need to change the collation on the user databases that exist. I would just like to make sure that all new databases are created using the new collation. Can I rebuild the master database without loosing my existing user databases? And if so, will they run OK using case insensitive collation, if the master is using case sensitive?Thanks in advance//RogerIts not dark yet, but it's getting there... |
|
|
rajeshk
Starting Member
15 Posts |
Posted - 2008-02-27 : 07:51:42
|
| After rebuilding the master database you have to recreate all the objects. After rebuild you can attach the existing user databases to the instance. The existing user databases will run without any issues even though collation of master database is different from user databases. Take the backup of all necessary objects before rebuilding the master database. Refer SQL server bol for more details on rebuilding master database. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-27 : 22:44:13
|
| >> will they run OK using case insensitive collation, if the master is using case sensitive?May have problem when sql uses tempdb for sorting or so. |
|
|
|
|
|
|
Change of Collation