>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 ?

Yes, if this is a SQL 7.0 server, the collation is server wide. IN SQL Server 2000 you can set the collation level at the object. A binary collation makes SQL Server case sensitive, right down to object names.

>
>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)

Nope, but in SQL 2000 you can set the collation of each object... I am not sure if you can do this for an SP...

BOb


>
>Thanks.