Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Converting SQL Server 7 to case insensitive
- Thread starter J2MO
- Start date
tlbroadbent
MIS
You don't have to reinstall but the situation is almost as bad as reinstalling. The following quote is from SQL BOL under the topic "Changing the Character Set, Sort Order, or Unicode Collation." This topic contains instructions for changing the collation.
"The character set, sort order, and Unicode collation are fundamental to the structure of all Microsoft® SQL Server™ databases. In order to change one or more of these settings, you must rebuild the master and user databases." Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
"The character set, sort order, and Unicode collation are fundamental to the structure of all Microsoft® SQL Server™ databases. In order to change one or more of these settings, you must rebuild the master and user databases." Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
- Status
Similar threads
- Locked
- Question
