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 - 2004-06-14 : 07:22:58
|
| Yonatan writes "Hi,I have to change the SQL Server because it has been installed with case-sensitive context, and I have a tool that can’t be installed on that way,How do I change this configure option?Thanks" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-14 : 08:17:18
|
| From Books Online:How to rebuild the master database (Rebuild Master utility) To rebuild the master database Shutdown Microsoft® SQL Server™ 2000, and then run Rebuildm.exe. This is located in the Program Files\Microsoft SQL Server\80\Tools\Binn directory.In the Rebuild Master dialog box, click Browse.In the Browse for Folder dialog box, select the \Data folder on the SQL Server 2000 compact disc or in the shared network directory from which SQL Server 2000 was installed, and then click OK.Click Settings. In the Collation Settings dialog box, verify or change settings used for the master database and all other databases. Initially, the default collation settings are shown, but these may not match the collation selected during setup. You can select the same settings used during setup or select new collation settings. When done, click OK.In the Rebuild Master dialog box, click Rebuild to start the process. The Rebuild Master utility reinstalls the master database.Note To continue, you may need to stop a server that is running.Do you already have other user databases installed though???? If so, there are other steps you need to take. You also need to let us know if you want to keep the collation the same or change it for the other databases.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
nakrono
Starting Member
1 Post |
Posted - 2004-06-14 : 12:35:12
|
| I do have other Databases and want to keep the same collation for them |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-14 : 14:02:08
|
| Ok. Then you just need to Create a new database with whatever collation you need. You can then restore their backup file into this database. That will be the easiest thing to do.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-14 : 15:13:34
|
| Well it had better be 2000 or forget it.Brett8-) |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-14 : 16:20:22
|
| Yeah, if this isn't SQL Server 2000, just go home and call it a day.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
|
|
case sensitive