The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

    • RT @sebvandenbrink: Je ziet Abraham wanneer je 50 wordt, wie zie je wanneer je 90 wordt? Asking for a grandmother... 18 minutes ago
    • RT @fmanjoo: Just behold all the resources we’ve given police. Look at all that military gear, enough to fight a civil war with citizens. A… 18 minutes ago
    • RT @andizeisler: I’m old enough to remember two weeks ago when mobs of white people armed themselves to the teeth and stormed state capital… 19 minutes ago
    • RT @Rubenhuisman1: DeLijn: We zetten extra bussen in zodat studenten naar hun examens kunnen en minder gevaar lopen. Meanwhile NS: StUdEnT… 34 minutes ago
    • RT @Foone: The clever bit of the heads of a double-sided 3.5" floppy drive: The heads aren't aligned with each other, they're offset by a l… 34 minutes ago
  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,920 other followers

When opening SQL Server Management studio with ssms command (+parameters) I need the Object Explorer to be filled and point to the right location – Stack Overflow

Posted by jpluimers on 2014/03/25

As a SQL Server developer, most of us make extensive use of SQL Server Management Studio.

With lots of production database, I have a directory full of shorcuts that pre-fill server/database/… on the command-line.

One of the drawbacks these shortcuts have is that the Object Explorer stays empty, and does not sync with the currently active Server/Database.

While browsing to solve that, I found that the

Alt+F8 shortcut will focus the SERVER in the Object Explorer.

This was explained by StackOverflow user Andrei Rantsevich who had this great answer on StackOverflow:

there is no native functionality in SSMS to implement it. There is a shortcut Alt+F8 which focuses SERVER in object exlorer, but not the database.

I have developed add-in for SSMS and have implemented function that you are looking for: it syncronizes current editor window with ObjectExplorer – database will be focused and expanded in the tree (you do not even need to have Server be opened in Object Explorer – it will be added in this case). Follow this Link to see feature description

Well, in SSMSBoost I have implemented the feature that dumps all commands and their shortcuts registered in SSMS, so you can look there for keywords like “server” or “focus” or other words and simply discover commands that you might need.

SSMSBoost is available for the 2008 and 2012 versions of SSMS both in a Free and Professional edition.



via: When opening SQL Server Management studio with ssms command (+parameters) I need the Object Explorer to be filled and point to the right location – Stack Overflow.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: