SQL Server Transact Basic to Expert - Configure a UnlimitedTimeout for Current Session

This blog shows how to configure a unlimited timeout to wait for current session in SQL Server

Example:

SET LOCK_TIMEOUT -1

This will wait for unlimited time out for the current session.