using query governer to limit long running queries in MS SQL 2005
We have a MS Access aplication that uses MS SQL 2005 as back end. We have a client that locks up when a particluar query is run. It does not happen all the time but when it does it appears that this query is the culprit. We are rewriting the query for the long term fix. For the short term i wanted to know if using the query governer to kill the query if runs too long (over 10000 ms) will do the trick? or am i just barking up the wrong tree?