transaction lock timeout settings

[jcalli]

I am building a stored procedure that needs to access and update several SQL Server tables simultaneously. Is there a way to set the timeout on the lock to rollback the transaction after 30 sec's? The problem is that I'm locking data elements in several tables simultaneously and I need for either all to commit or all to rollback and I need to put a time limit on the timeout if there is a problem.

Thanks,

 

[foxdev]

How about SET LOCK_TIMEOUT?
You can also check the current setting using @@LOCK_TIMEOUT.

--------------
art prints

http://www.artlot.com