Tip #1 SQL Query Timeout Configuration and Errors

go site --See current system configurations SELECT * FROM sys.configurations WHERE configuration_id IN (1519,1520,1541,1557); --See what is current setting SELECT @@LOCK_TIMEOUT --Wait up to 5 ms for the SQL text waiting on lock resource, then give up SET LOCK_TIMEOUT 5; --Return this to the default SET LOCK_TIMEOUT -1; --System error messages related to timeout SELECT message_id, [text] FROM sys.messages WHERE language_id = 1033 AND ([text] LIKE '%timeout%' OR [text] LIKE '%time out%')