Hi,
I am using SQL Server 2000 and have a stored procedure that takes around 40 seconds to execute from SQL Query Analyser
When I call the same SP from my LLBL generated code, the application hangs, however if I adjust the SP so that it runs in under 30 seconds it works perfectly....
Is there any way that I can adjust the timeout for the SP so that my code does not hang
Regards
Huw
Additional Info:
No exception is thrown by LLBL it simply gets "stuck" at the line of code executing the action procedure.
The reason that I know it is a timeout issue is that you get a similar result in SQL Enterprise Manager whereby if you run a query that takes over 30 seconds it throws a timeout erro, however running the same query in SQL Query analyser does not timeout.
