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
 Other SQL Server 2008 Topics
 Web Service receives no data from Stored Procedure

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
   

- Advertisement -