When you try to run a query in a query editor in SQL Server Management Studio, a query in a different query editor runs instead

When you try to run a query in a query editor in Microsoft SQL Server Management Studio, a query in a different query editor runs instead.

Consider the following scenario in Microsoft SQL Server 2005:

• You open two query editors in the same instance of SQL Server Management Studio.
• You put a query in the first query editor, and then you put a query in the second query editor.
• You enable the Display results in a separate tab option in the first query editor.
• You run the first query. Then, while the first query is running, you change the focus to the second query editor.
• After the first query has finished, you try to run the second query.

In this scenario, the second query does not run. Instead, the first query runs again.

This problem occurs because the focus returns to the first query editor when the first query has finished. If the Display results in a separate tab check box is selected in the first query editor, the Results tab in the first query editor is automatically enabled when the first query is finished. Therefore, the focus automatically returns to the first query editor, even though you have selected the second query editor.

Service pack information

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

To work around this problem, use one of the following methods:

• After the first query has finished, click the tab of the second query editor to change the focus to the second query. Then run the query in the second query editor.
• Before you run the query in the first query editor, clear the Display results in a separate tab check box in the Query Options window. (For more information about how to do this, see the "MoreInformation" section.) Run the query in the first query editor. Then run the query in the second query editor.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Microsoft SQL Server 2005 Service Pack 1.

Steps to reproduce the problem

1. Open two query editors in the same instance of SQL Server Management Studio.
2. Put a query in the first query editor, and then put a query in the second query editor.
3. In the first query editor, click the Query menu, and then click Query Options.
4. Click Result in the left pane.
5. Click Display results in a separate tab, and then click OK.
6. Run the query in the first query editor. While the query is running, click the tab of the second query editor to bring it to the front.
7. After the query in the first query editor runs, run the query in the second query editor.

When you do this, the second query does not run. Instead, the first query runs again.