SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

At Startup SSMS setting

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.


My name is Kenneth Fisher and I am Senior DBA for a large (multi-national) insurance company. I have been working with databases for over 20 years starting with Clarion and Foxpro. I’ve been working with SQL Server for 12 years but have only really started “studying” the subject for the last 3. I don’t have any real "specialities" but I enjoy trouble shooting and teaching. Thus far I’ve earned by MCITP Database Administrator 2008, MCTS Database Administrator 2005, and MCTS Database Developer 2008. I’m currently studying for my MCITP Database Developer 2008 and should start in on the 2012 exams next year. My blog is at www.sqlstudies.com.


Leave a comment on the original post [sqlstudies.com, opens in a new window]

Loading comments...