Today I just started getting this message:
I'm also getting this error message:
Msg 1222, Level 16, State 52, Line 1
Lock request time out period exceeded.
I think this comes from Tools > Options > Query Execution.
The Execution Timeout is set to 120 seconds, and my query times out after 6 seconds.
If I hit Reset to Default, Execution Timeout goes to 0, and the query still times out after 6 seconds. How can I set this to work for ANY TIME PERIOD?
Thanks!!
Knowledge is the only thing that I can give you, and still retain, and we are both better off for it.
Go to the complete details ...