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
Sunday, March 16, 2008
SQL SERVER update @@LOCK_TIMEOUT
at 1:20 PM Posted by roni schuetz
Labels: Database, SQL Server
Subscribe to:
Post Comments (Atom)
Shared Cache - .Net Caching made easy
All information about Shared Cache is available here: http://www.sharedcache.com/. Its free and easy to use, we provide all sources at codeplex.
No comments:
Post a Comment