In sp_serveroption there is an option of timeouts.
Is there any way by which i can come to know that its set to True or False.
I know how to set this value to True or False but i dont know how to check its current value.
select v.name ServerOption
,case when s.srvstatus & v.number = v.number then 'True' else 'False' end
from master..sysservers s, master..spt_values v