Another "hidden" feature of SQL 2005

[Catadmin]

Well guess what I just discovered by accident? @=)

You know how you can't cursor through the open query window tabs to get to one that wasn't showing on your screen? You have to use the drop down arrow (or go to WINDOWS on the main menu) to find it?

Well, I may have a solution for you. Found it by accident just a moment ago. If you want to keep a specific tab visible while doing work on another couple of tabs, click the tab in question and drag it down into the query window. When you release it, a pop-up box will give you the option of "New Horizontal Tab Window" or "New Vertical Tab Window". You can do 2 side-by-side (or top-by-bottom if you want to be technical) windows for your queries in the same instance of SSMS.

This is FUNNY. I'm discovering undocumented features of SQL 2005 by being fumble fingered on my mouse. @=)



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

You can also right click on the tab to get the popup menu.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com