QueryTimeout Property

SQL-DMO

SQL-DMO

QueryTimeout Property

The QueryTimeout property specifies the number of seconds elapsed before a time-out error is reported on an attempted statement execution.

Applies To
LinkedServer2 Object SQLServer Object
Syntax

object.QueryTimeout [= value]

Parts

object

Expression that evaluates to an object in the Applies To list

value

Long integer that specifies the number of seconds

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetQueryTimeout(LPLONG pRetVal);

HRESULT SetQueryTimeout(LONG NewValue);

Remarks

To specify that a query cannot time out, use -1 (the default) or 0.