I written a procedure to search hotel based on particular hotel name or based on a cityID. The procedure returns 10 tables.The procedure work fine...executing in 1 milisecond in SSMS.
The problem is after 2-3 days the result is not displaying in the front end(C# and Asp.net) but the result is coming in backend when i execute through SSMS.
When the results are not coming...I drop the procedure and recreate it, then it display results in frontend.
Any idea why this problem occuring