Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. BUG: Opening a Long-Running View from SQL Server Enterprise Manager Gets ODBC Timeout

BUG: Opening a Long-Running View from SQL Server Enterprise Manager Gets ODBC Timeout

View products that this article applies to.

This article was previously published under Q247070
BUG #: 54929 (SQLBUG_70)
BUG #: 352122 (SHILOH_BUGS)

↑ Back to the top

Symptoms

Opening a view that executes a long running query in the SQL Server 7.0 Enterprise Manager (SEM) will get an ODBC Timeout error.

↑ Back to the top

Cause

The SEM's default for QueryTimeout is 30 seconds, and the timeout value is not configurable.

↑ Back to the top

Resolution

Do not open long running queries from the SEM. Run the query from Query Analyzer instead of SEM.

↑ Back to the top

Status

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top

Keywords: KB247070, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 247070
Revision : 6
Created on : 12/5/2003
Published on : 12/5/2003
Exists online : False
Views : 468