SQL Server Transact Basic to Expert - Configure a Session Timeout to wait for Particular time


This blog shows how to configure a timeout to wait for some milliseconds in SQL Server

Example:

SET LOCK_TIMEOUT 1000

This will wait for 1000milliseconds for the current session.