At Startup SSMS setting


August 26, 2012 by Kenneth Fisher

I came across this handy dandy little setting earlier this year.  It was well hidden from me, by which I mean it’s the very first setting on the first tab of the options window.

When SSMS (SQL Server Management Studio) first opens, it requests connection information that it uses to open an Object Explorer connection.  Now, who here has found this behavior very frustrating?  Wouldn’t it be nice if it could be changed?  Well as it happens it can.

This setting has five options:

Open Object Explorer
Open new query window
Open Object Explorer and new query
Open Object Explorer and Activity Monitor
Open empty environment

Personally I like “Open Object Explorer and new query” since I most often use query windows, but I do like to have an Object Explorer available also. 

I have to say I think this is one of my favorite settings.

FYI For those who don’t know you can get to the options window from the Tools » Options menu.

3 thoughts on “At Startup SSMS setting

  1. […] absolutely love learning new tricks that can be done in SSMS. Everything from opening initial connections to both the object explorer and a query window to changing the font that the query windows use. Recently I learned a new one while watching a SQL […]

  2. […] Change the At Startup setting. This setting let’s you pick what type of connection gets opened when you first open SSMS. So you can have Object Explorer open, a New Query open, both or neither. My preference is neither. […]

  3. […] Control what connections open when starting SSMS. […]

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 )

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.

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

Join 3,753 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: