FIX: Query Analyzer Stops Responding and Cannot be Started Until Visual Studio Analyzer is Stopped

While the Visual Studio Analyzer is active, the SQL Server Query Analyzer window may not appear. After you select Query Analyzer from the Start menu, an hourglass icon displays briefly. However, the Query Analyzer window does not display when the hourglass icon reverts back. Both the SQL Server Profiler and Index Tuning Wizard also display the same symptoms.

This problem is observed only when the following products are installed on the same computer:

• Microsoft Windows 2000 or Microsoft Windows NT 4.0 Server
• Microsoft Visual Studio Enterprise Edition (including Visual Studio Analyzer)
• SQL Server 2000

To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

To work around this problem, disable the Visual Studio Analyzer. You can use the steps that follow to disable Visual Studio Analyzer.

Microsoft Windows 2000

1. On the Taskbar click Start, point to Administrative Tools, and then click Data Sources (ODBC).
2. Click the Tracing tab in the ODBC Administrator dialog box.
3. Click Stop Visual Studio Analyzer to stop the Visual Studio Analyzer. If the command button is titled Start Visual Studio Analyzer before being clicked, then you are not being affected by the problem described in this article.
4. After you click Stop Visual Studio Analyzer, the title changes to Start Visual Studio Analyzer. Now, if an attempt is made to open the SQL Server Query Analyzer window, the window opens successfully.

Microsoft Windows NT 4.0

1. On the Taskbar click Start, point to Settings, and then double-click Control Panel. In the Control Panel dialog box, click ODBC Data Source Administrator.
2. Click the Tracing tab in the ODBC Administrator dialog box.
3. Click Stop Visual Studio Analyzer. If the command button is titled Start Visual Studio Analyzer before being clicked, then you are not being affected by the problem described in this article.
4. After you click the button, the title changes to Start Visual Studio Analyzer. Now, if an attempt is made to open the SQL Server Query Analyzer window, the window opens successfully.

Microsoft has confirmed this to be a problem in SQL Server 2000. This problem was first corrected in Microsoft SQL Server 2000 Service Pack 2.

Steps to Reproduce Behavior

Windows 2000

1. On the Taskbar click Start, point to Administrative Tools, and then click Data Sources (ODBC).
2. Click the Tracing tab in the ODBC Administrator dialog box.
3. Click Start Visual Studio Analyzer, which will start the analyzer. The title on the button changes to Stop Visual Studio Analyzer.

Windows NT 4.0

1. On the Taskbar click Start, point to Settings, and then double-click Control Panel. In the Control Panel dialog box, click ODBC Data Source Administrator.
2. Click the Tracing tab in the ODBC Administrator dialog box.
3. Click Start Visual Studio Analyzer, which will start the analyzer. The title on the button changes to Stop Visual Studio Analyzer.

An attempt to open SQL Server Query Analyzer fails to open the Query Analyzer window. Task Manager lists Isqlw.exe as being started and executing in the process list.

NOTE: Visual Studio Analyzer is a tool that is available with Microsoft Visual Studio Enterprise Edition. For more information about Visual Studio Analyzer, see the following Web site: