I’ve had a DBCC CHECKDB fail a handful of times recently because Toad had a lock on the hidden system table sys.sysrscols.
The query beign run in Toad when I checked most recently was a mere select statement on a small table. The lock was held for a few days before I killed the connection.
Anyone know why this might happen? Is it a setting in Toad that gets really aggressive with locks?
Thnks for your help!