InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 09:40:14 GMT20http://www.sqlservercentral.com/Forums/Topic1365064-391-1.aspx[quote][b]dilipd006 (9/27/2012)[/b][hr]Hi I written a procedure to search hotel based on particular hotel name or based on a cityID. [b][size="2"]The procedure returns 10 tables[/size][/b].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[/quote]Can you post the code?Mon, 08 Oct 2012 02:39:42 GMTChrisM@Workhttp://www.sqlservercentral.com/Forums/Topic1365064-391-1.aspxParameter sniffing possibly?[url]http://www.simple-talk.com/sql/t-sql-programming/parameter-sniffing/[/url]Mon, 08 Oct 2012 02:16:25 GMTAbu Dinahttp://www.sqlservercentral.com/Forums/Topic1365064-391-1.aspxAny help?Mon, 08 Oct 2012 01:14:02 GMTSQL006http://www.sqlservercentral.com/Forums/Topic1365064-391-1.aspxHi 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 occuringThu, 27 Sep 2012 01:25:31 GMTSQL006