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 |
|
jgrant
Yak Posting Veteran
69 Posts |
 Posted - 2007-09-16 : 13:24:27
|
| I have a stored procedure that I have been using for a long time. For some reason now, the stored procedure will not pass back any parameters. I checked each step and the row is returned and the variable is set but when I run the stored procedure the variable is always empty even though I know its set within the sp. Has anybody had this happen?The Yak Village Idiot |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-16 : 13:26:30
|
No, but please post the SP.Maybe it has something with your upgrade to SQL Server 2005?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
jgrant
Yak Posting Veteran
69 Posts |
Posted - 2007-09-16 : 13:52:40
|
| Im sorry, that was not the correct question yet. I am not sure what the right question is. Somehow a system that we have been using for many months is beginning to somehow fall apart. The value of variables are being dropped or lost and I am not sure why yet. I will keep you posted about what is going on as soon as I know more. Thanks always for your help Peso.The Yak Village Idiot |
|
|
|
|
|
|
Weird Results From Stored Procedure