Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Different SQL Server Management Studio Startup Options


By:   |   Read Comments (1)   |   Related Tips: 1 | 2 | 3 | 4 | More > SQL Server Management Studio

Attend this free live MSSQLTips webcast

Tips and Tricks to Growing Your SQL Server Estate from SMB to Enterprise Scale
Thursday, June 28, 2018 - click here to learn more


Problem

One of the developers asked me if there was a way to open Object Explorer and a New Query Window at the same time whenever he opens SQL Server Management Studio. In this tip we will take a look at different SQL Server Management Studio startup options which can benefit you in your day to day work.

Solution

SQL Server Management Studio is widely used by SQL Server DBAs and developers in their day to day SQL development work. One can change SQL Server Management Studio startup options by selecting Options from the Tools menu as shown in the snippet below.

looking at different ssms start up options

In the Options dialog box expand Environment and then select the General tab. In the "At Startup" drop down, to satisfy our need we would chose the "Open Object Explorer and new query" option from the drop down list and click OK. In order to see this change take affect, you need to close and re-open SQL Server Management Studio.

after the changes, you need to re-open sql server management studio

Different SQL Server Management Studio Startup Options include:

  • Open Object Explorer: This is the default option configured in SQL Server Management Studio (SSMS). In this option whenever SSMS opens up and the user credentials are validated, SQL Server Database Engine will be displayed in the Object Explorer.
  • Open New Query Window: When this option is selected, SSMS opens up an empty TSQL Query window once you are connected to a SQL Server Instance.
  • Open Object Explorer and New Query: When this option is selected, SSMS opens up Object Explorer and a new TSQL Query window once you are connected to a SQL Server Instance.
  • Open Object Explorer and Activity Monitor: When this option is selected, SSMS opens up Object Explorer and Activity Monitor once you are connected to a SQL Server Instance. This is the only option which is new in SQL Server 2008 Management Studio. To learn more about Activity Monitor and its advantages you can read the following Performance Analysis Using SQL Server 2008 Activity Monitor.
  • Open Empty Environment: When this option is selected, SSMS will not ask you to connect to a SQL Server Instance.
Next Steps


Last Update:


next webcast button


next tip button



About the author





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Monday, February 23, 2015 - 6:16:15 AM - k.Dinesh kumar Back To Top

sir i was trouble in sql server 2008.I can create datebase and inser various tables with out using queries.When i want to chang

the date types without using query.When i was change datatype and save the table it can display error message.So please send

tips to change date type without delete table.


Learn more about SQL Server tools