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.
| Author |
Topic |
|
hwdev
Starting Member
17 Posts |
 Posted - 2005-05-02 : 18:53:20
|
My db was recently changed to be CS. I changed my stored Procedure to use collate Latin1_General_BIN in the where clause and it seems to execute fine. Does anyone know if there is a Set statement I must use because when I execute my SP from my ASP page, it is not returning the data, but when I execute my SP outside of my ASP page it works fine.   |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-05-02 : 19:05:58
|
| Are you calling the stored procedure with the correct case? If the database collation has been changed then it affects object names as well as data. |
 |
|
|
hwdev
Starting Member
17 Posts |
Posted - 2005-05-02 : 19:32:23
|
| I am not sure what you are asking? I haven't changed anything and I am calling it as follows;cmd.CommandText = "BCSP_INT_DIAG_PROC_CODES" Is there something different I need to do or is there a particular SET statement I need to set in my Stored Procedure? |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2005-05-03 : 11:12:46
|
| is that the exact name of the SP in SQL? "BCSP_INT_DIAG_PROC_CODES" != "BCSP_Int_Diag_Proc_Codes" when you have CS on. |
|
|
|
|
|
|
Case Sensitive Problem