I have a weird problem here that I can't seem to figure out. Here's the jist of it:
When a certain VB application executes a stored procedure via an RPC call, it ends up timing out (beyond 5 minutes). I verified that the SQL server is indeed receiving the RPC call (it shows up in Profilder, and Ethereal). The VB app terminates the process after 5 mintues because the SP apparently is still going.
When I execute the SAME stored procedure using the same paramters from Query Analyzer, it takes 25 seconds.
I have some index tuning plans I will implement soon that will take it from 25 down to 1 seconds or less using the Analyzer, but, I still don't know why it times out from the RPC call.
So my question is, what's the main difference here that makes the Query Analyzer so much quicker?
Thanks for the help.