case sensitive making some problem.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

case sensitive making some problem.

Author

Topic

smartmoon
Starting Member

1 Post

Posted - 2011-05-30 : 13:53:25

Hi All,

We created the database with the option collation="SQL_Latin1_General_CP1_CI_AS". We have created some stored procedures. We took the backup and send it to pilot land scape. Pilot land scape people restored the backup. When they are executing the stored procedures, it is not working. We found that the problem is the behaviour of stored procedure is case sensitive.
Can any one help me in resolving this issue.

Example:

Create procedure sp_test
as
begin
select * into #TEMP_TABLE from table
select * into #TEMP from #temp_table
end

executing the above stored procedure giving the error:

...[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot find the object "#temp_table" because it does not exist or you do not have permissions.

Thanks
SmartMoon

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2011-05-30 : 14:57:19

I have not run into this problem myself, but when I saw your post, I googled for it and found this article which may be useful to you: http://sqlserverperformance.idera.com/uncategorized/consider-collations-carefully/

Also, there are links to two other articles in this article that may be useful as well.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources