From: "sysadmin.rock[SINESTO]"@gmail.com   
      
   On 06-05-2011 17:52, Erland Sommarskog wrote:   
   > Wishmaster ("sysadmin.rock[SINESTO]"@gmail.com) writes:   
   >> what i'm trying to say is there not any result set on my website and no   
   >> error message as well. But if i run the stored procedure from Mgnt   
   >> Studio takes arround  3 minutes to produce a result set.   
   >> I'm going to check your suggestions.   
   >   
   > Three minutes is a tad long for a search from a web page. Since the default   
   > timeout in most client API is 30 seconds, I suspect that you get a timeout.   
   >   
   > I have an article on my web site that discusses various strategies   
   > for these kind of searches, including the one you are using.   
   >   
   >   
   Erland,   
      
   This morning it happened again, but we research it about the recompile   
   option that you suggested and we used it. Now i'm going to track this   
   particular issue. I will tell you how it goes later.   
   Thanks,   
      
   PD: what is the link of your website?   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)