July 15, 2005 at 2:40 pm
I am having a problem when I installed SQL, I installed it as case sensitive but I want to add a database that is case insensitive. I can add the database as case insensitive, according to the properties on it, but when I try to run a SQL script in query analyzer to create some stored procedures, it acts like it is still case sensitive because I have variable names in there and if they are not the same case, it tells me that I have to declare them. Any ideas?
Thanks,
Shawn
July 18, 2005 at 8:00 am
This was removed by the editor as SPAM
July 18, 2005 at 8:30 am
What is the server default collation and what is the database in question collation?
July 18, 2005 at 8:32 am
The server default collation is case sensitive and the database collation is case insensitive.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply