Hi BillTurner-1472,
The default lock timeout limit is -1, which is unlimited.
You can change the lock timeout limit in SSMS Options->Query Execution > Advanced.
And one cause for this issue is to have uncommitted or non-rollback transactions.
You can use implicit transactions, then run the update query without committing.
Best Regards,
Daniel Zhang
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.