Timing a Query

[ghoff12]

I am running a query, and i want to stop the query if it taking longer than 20 seconds.

Does anyone know how i can do this?

Any info would be great.

[monte96]

Use a command object and set the CommandTimeout property

[ghoff12]

Ok, well bascially what i wanna do is stop the query.

If its takes longer than 20 seconds, i want a message box to pop up, and ask if the would like to contineu processing the query. if they click yes, it continues, if no, then will cancel it.

any ideas how to do this?