Hi Experts, How to set the query Timeout to 10 seconds. I checked it using sp_configure and it shows 600 seconds for remote query timeout. I changed it using sp_configure 'query timeout',10 The above command executed & displayed changed setting. But still when i ran a query in QA which takes more than 5 mins. doen't time's out Why is this happening. Is there any other setting i need to change.. I hope you got what i wanted...? I need to cancel those queries running from QA to be time out in 10 second taking more than that... Thanks.