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 |
|
SadiStick
Starting Member
2 Posts |
 Posted - 2004-07-29 : 16:39:51
|
| Hey folks,I am brand new to this website of yours, and so far I have done many searches to no avail.My question is this, can I, and if so, how, would I convert a case sensitive SQL install to a non-case sensitive install...either SQL 7 or SQL 2000?This is really urgent, so any replies would be much appreciated.Cheers-SS |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-29 : 16:47:47
|
You have to rebuild master to change the server's collation.From SQL Server Books Online:quote:
To change the default collation for an instance of Microsoft® SQL Server™ 2000 you must: Make sure you have all of the information or scripts needed to re-create your user databases and all of the objects in them.Export all of your data using a tool such as bulk copy.Drop all of the user databases.Rebuild the master database specifying the new collation.Create all of the databases and all of the objects in them.Import all of your data. Note Instead of changing the default collation of an instance of SQL Server 2000, you can specify a default collation for each new database you create.
Tara |
 |
|
|
|
|
|
Urgent Help Needed!