General information
Forum:
Microsoft SQL Server
>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only