• :exclamationmark: I have a definite problem with this QOD. WHICH VERSION? When the version is missing, I assume that the question is referencing the most current version and not the one that is on extended support. The link provided is for SS2000. I believe that if the question was answered correctly for either of these versions, then the points should be given and the question marked as correct. The QOD SHOULD include the version that the question is about. Not having the version CAN cause the wrong answer, and thus the arguments seen lately.

    Having "assumed" SS2008, I answered 0. For 2005 and 2000, the answer is leave it empty. (See below)

    SQL Server 2000

    Timeout

    Type the number of seconds until the query times out. The default is 30 seconds. The value for Timeout must be empty or greater than zero. If it is empty, the query does not time out.

    SQL Server 2005

    Timeout

    Type the number of seconds that the report server waits for a response from the database. The default value is 30 seconds. Timeout must contain a value greater than zero or be left empty. If it is empty, the query does not time out.

    SQL Server 2008

    Timeout

    In Timeout, type the number of seconds that the report server waits for a response from the database. The default value is 0 seconds. When the time out value is 0 seconds, the query does not time out.

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan