Global Lock Timeout

Hello,
Is there a way I can set lock timeout globally for the SQL Server
Thanks
Peter
no.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Peter Nolan" <PeterNolan@.discussions.microsoft.com> wrote in message
news:EE67D8E0-C7E9-4935-BA07-FB97A675BAE3@.microsoft.com...
> Hello,
> Is there a way I can set lock timeout globally for the SQL Server
> Thanks
> Peter

Global Lock Timeout

Hello,
Is there a way I can set lock timeout globally for the SQL Server
Thanks
Peterno.
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Peter Nolan" <PeterNolan@.discussions.microsoft.com> wrote in message
news:EE67D8E0-C7E9-4935-BA07-FB97A675BAE3@.microsoft.com...
> Hello,
> Is there a way I can set lock timeout globally for the SQL Server
> Thanks
> Peter

Global Lock Timeout

Hello,
Is there a way I can set lock timeout globally for the SQL Server
Thanks
Peterno.
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"Peter Nolan" <PeterNolan@.discussions.microsoft.com> wrote in message
news:EE67D8E0-C7E9-4935-BA07-FB97A675BAE3@.microsoft.com...
> Hello,
> Is there a way I can set lock timeout globally for the SQL Server
> Thanks
> Peter

GLobal Lock Timeout

Is there any way to set a SQL instance to a default lock timeout value? From my understanding, this can be set per session but not globally. I think that any thread waiting longer than say 5 minutes for a lock should fail and would like this make the default in some of our servers.Are you talking about Query Timeout setting on the server?|||Originally posted by rdjabarov
Are you talking about Query Timeout setting on the server?

Maybe. Is the Query Timeout check box in the server Connection tab the default timeout value for locks?|||The check box in the server properties is for Remote queries which is intended to account for network latency and other delays. This is set to 600 (the default i think). However, this does not effect the lock timeout limit.