Why do I get the following message ?
Error : "A background query has been paused. On this database this can cause an exclusive Lock to be held on the tables involved. Do you want to cancel the query?"
Toad for SQL server has an option in /Database/General/Number of rows to initially fetch from a query which is default to 1000, so for large tables, it only fetches a chunk of all rows and release the connection, it makes toad response faster.
WORKAROUND:
To avoid seeing this message, you can either check "Don't show the message in the future" or set the initial fetch to unlimited.
NOTE: This will downgrade performance
Set the initial fetch to unlimited as follows
1) Tools | Options | Database | General |
2) Check unlimited for number of rows to be initially fetch
