Problems in database query timing out

[Bonj]

When I am in a database project in VS.NET 2003 EA, using the Run Stored
Procedure option times out even though the timeout option in Tools, Options,
Database Tools is not checked.
Anybody else experienced this?

[Ignacio Machin \( .NET/ C# MVP \)]

Hi ,

Not at all, mine runs fine, it's a super cool feature as you even get a
popup asking for the parameters.

Does the SP runs fine from query analyzer?

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Bonj" <Bo**@discussions.microsoft.com> wrote in message
news:99**********************************@microsof t.com...

When I am in a database project in VS.NET 2003 EA, using the Run Stored
Procedure option times out even though the timeout option in Tools, Options, Database Tools is not checked.
Anybody else experienced this?

[Bonj]

Yep, although it does take a long time (upwards of an hour).
Although it still times out on ones that take less than that, say 10 minutes.
Try running an SP that takes a *long* time and see what you get...
It times out for me after about a minute.

I'm thinking perhaps they defined a timeout setting, but assumed there could
be a blanket upper limit on it anyway whatever it is set to?

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

Well 1 hours SP is a LONG SP :)

no wonder it does timeout :)

I;m not very sure of how the timeout is implemented in the IDE, you should
ask in either the IDE or SQL NGs and PLEASE especify that the SP takes up
to 1 hour to execute !!

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Bonj" <Bo**@discussions.microsoft.com> wrote in message
news:31**********************************@microsof t.com...

Yep, although it does take a long time (upwards of an hour).
Although it still times out on ones that take less than that, say 10 minutes. Try running an SP that takes a *long* time and see what you get...
It times out for me after about a minute.

I'm thinking perhaps they defined a timeout setting, but assumed there could be a blanket upper limit on it anyway whatever it is set to?