how do i stop a query that is taking a log time?

hello,

how can i stop a query running,
the button will be on a web application
code is vb.net
the query collects data from a inSQL database on the web server

anybody got any ideas?

Tom.

That's a really interesting question. I hope you get an answer. If it is possible, I suspect it would be by setting a time limit before you execute the query.

Well i should be change the timeout value. Not anywhere near VB .Net at the moment but I would guess it's a property of the connection that can be changed.

I'm not in front of a VS.NET machine but I guess the SQLCommand object should have a timeout property