SQL SERVER update @@LOCK_TIMEOUT

After installation the default value of @@LOCK_TIMEOUT is -1. Even if the Connection properties window shows 15 sec.

So if you have a time consuming SQL statement to update something like I had to do today:

UPDATE WorldCitiesPopulation
SET Population = '-1'WHERE (Population = '')

It updated quite a lot of rows: 2652350 row(s) affected; so the default value of 15 sec. is not enough on my machine. To update Timeout you simply execute the following:

SELECT @@LOCK_TIMEOUT
SET LOCK_TIMEOUT 180000
SELECT @@LOCK_TIMEOUT