I'm running into a problem specific to an installation of an SQL Server instance that was done by the client.

It seems to be case sensitive at TSQL level. If the usage of local variables does not match the case of the declaration, the variable is not recongnized.

In BOL, I can see how, at installation time, to specify if we want a case sensitive instance.

Questions:

1- Is there a way to change this once installed ?

2- Is the a statement I could put in my procs that will override this ? (LIKE: SET NOCOUNT ON will get rid of the count)

Thanks.