Using SSMS, in the Object Explorer, when I drill down to database D1 and right click on table T1 and choose "Select Top x Rows", the query window that opens is connected to the "master" database, not database D1.

Is there any way to configure SSMS to connect new query windows to the database they are doing the query in?

Thanks,
Glen

Yep, known issue, might be improved in a future release if enough people
support it.

http://connect.microsoft.com/SQLServ...spx?FeedbackID
=367434

Sure, right-click the correct database in Object Explorer, select "New
Query" in the drop-down. Then type "SELECT TOP 25 * FROM table_name", add
an ORDER BY clause, and you're off to the races.

Thanks. I added a vote to that feedback page.

"Aaron Bertrand [SQL Server MVP]" <ten.xoc (AT) dnartreb (DOT) noraa> wrote