Microsoft KB Archive/136654

{|
 * width="100%"|

BUG: Set Query Timeout Fails w/ Named Pipes, TCP/IP, IPX/SPX

 * }

Q136654

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

BUG# NT: 11246 (6.00)

SYMPTOMS
When you choose File, Configure from the drop-down menu in ISQL/w, the Configuration dialog box appears. If you click the Connection tab and set the Query timeout to n seconds, no query will time out after n seconds.

CAUSE
With configurations of Named-Pipes, TCP/IP or IPX/SPX Net-Libraries, the Query Timeout is fixed at zero, which means a query will run indefinitely.

STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: sql6 utility isql connection run

Keywords : kbtool

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600