How to remove "case-sensitive" property in SQL Server 7.0 Instance?
-
Hi all,
I have a problem with SQL Server 7.0 (Enterprise Edition). I don't know Why my SQL Server 7.0 instance is case-sensitive. How to remove its?
Pls give to me some suggetions. Thanks a lot.
AnhNT.
-
AFAIK in SQL7 this calls for a reinstall / rebuildmaster at least.
_and_ recreate all userdb and import all data again
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Hi alzdba,
AFAIK stand for ... ?
Could you show me how SQL Server 7.0 set Case-sensitive while reinstalling?
Thanks.
-
AFAIK = as far as I know
When you install sql7 there is a window for the charcterset/sort order/collation selection.
There are checkboxes to set case-insensitive,...
Check out http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnarsql7/html/sql7install.asp
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
I have solved successfully my problem follow to your suggestion. Thank you very much, alzdba.
AnhNT
-
Great
by the way : http://www.geocities.com/SouthBeach/Lagoon/9819/acronyms.html
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply