ADP Stored Procedure timeout

J

Jason V

I have a Stored Procedure with many subqueries. It timeout even when I set
the timeout to 0 (infinity). I can run the same exact query using the SQL
Query analyzer and it runs in three seconds. Can anybody help?
 
S

Sylvain Lafontaine

If you have really set the timeout to infinity, then your stored procedure
shouldn't never time out and either you would have your result by now or you
would still be waiting for it.

Usually, executing a SP under ADP shouldn't be very different in time from
running it from the Query analyser; so your problem is probably something
else than a timeout problem.

There is a newsgroup about ADP: m.p.a.adp.sqlserver .
 
Top