Case-sensitive stored procedures

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gav - 26 Mar 2008 14:25 GMT

I have a SQL 2000 database server with the server collation set to
SQL_Latin1_General_CP850_BIN and one of the databases with a collation of
SQL_Latin1_General_CP1_CI_AS which has been created by an external company.
Problem I have is that on this server stored procedures are case sensitive
and the database (SQL_Latin1_General_CP1_CI_AS) has stored procedures that
have been written without case sensitivity in mind (the procedures do not
work). So I have a few questions.

1. Is the reason for the stored procedure case sensitivity due to the server
collation? ie. It is server specific rather than DB specific.
2. Can this be changed?

thanks

Gav

Reply to this Message

Davy Shipley - 27 Mar 2008 16:21 GMT

The collation that is CI is a default configuration, so that's probably why
the external company gave it that way.
You can modify the collation of the database to be the same as yours.

If it won't affect the sp's speed, you could put collation hints on any
joins between the databases without changing the db collation.

>I have a SQL 2000 database server with the server collation set to
>SQL_Latin1_General_CP850_BIN and one of the databases with a collation of
[quoted text clipped - 11 lines]
>
> Gav

Reply to this Message