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.