June 11, 2002 at 11:57 am
I have inherited a SQL Server database that is not case sinsitive when dealing with Strings. I am wondering if there is way to change the database properties so that it is case sensitive.
Thanks Steve
June 11, 2002 at 1:53 pm
SQL 7 or 2k? If you have SQL2K I'd suggest looking at only changing the columns that matter, not the whole db.
Andy
June 11, 2002 at 3:32 pm
With SQL 7 you have to export the data then rebuild the server with Case sensitive on then import the data back in.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply