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.