For what period does the
I do a
SET LOCK_TIMEOUT 10 and a
SELECT @@LOCK_TIMEOUT in one command after a login and get 10 returned. Immediately after this I do a
SELECT @@LOCK_TIMEOUT again and it returns -1. I would have thought it still be 10.
I did some looking on the MSDN site and could not find if the
LOCK_TIMEOUT is session based or statement based.