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 |
|
allenhadler
Starting Member
3 Posts |
 Posted - 2014-02-14 : 11:28:56
|
| Issue: When calling a Stored Procedure from a Web Service no data is returned.Lead up: I can call the SP 100 times a day for 3-4 days then for some reason the Web Service no longer get the data from SQL. I have ran a trace and I can see the SP running though all of its steps and returning the data, but the Web Service is not getting it.Fix: None yet.Work around: Before the Web Service calls the SP, I am sending an SP_Recompile to the SP in question. For now this seems to have resolved the issue.Detail: 1. SP is querying data from another DB on the same server.2. SP is storing query data in Temp Tables.Allen Hadler |
|
|
|
|
|
Web Service receives no data from Stored Procedure