October 10, 2001 at 10:36 am
I inherited 2 servers with the IDENTIFIER_CASE set to SENSITIVE and I was wondering if anyone has figured out how to change this without having to reinstall SQL on the Server.
Any input would be greatly appreciated.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 10, 2001 at 11:24 am
October 10, 2001 at 2:27 pm
Both are 7.0! Thoughts? TIA
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 10, 2001 at 4:00 pm
In 2000 there are a number of collation type options that can be reset per db. In 7.0, I do not think this is an option. Sorry, I do not have any 7.0 servers here to check. My guess is that you need to reinstall. The best way would be to detach all databases and then reinstall. Check also rebuilding master with a new setting in yor 7.0 Books Online. Once you are reset, you can reattach your dbs.
Steve Jones
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply