Message "Query was cancelled"
kev1609
Posts: 16 Bronze 2
Hi,
Started getting the message "Query was cancelled" against a couple of servers in a group that I use multiscript to update. The queries in question can then be executed directly on the servers, or I can use SQL Compare to sync then (the queries are schema updates, eg creating a new stored procedure). Queries selecting data work okay. Any suggestions on how I might track down what is causing the problem?
Kev
Started getting the message "Query was cancelled" against a couple of servers in a group that I use multiscript to update. The queries in question can then be executed directly on the servers, or I can use SQL Compare to sync then (the queries are schema updates, eg creating a new stored procedure). Queries selecting data work okay. Any suggestions on how I might track down what is causing the problem?
Kev
Comments
I have logged a support ticket for you and email you shortly.
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com