For what period does the LOCK_TIMEOUT LAST?
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.