:::: MENU ::::

Customize SSMS startup environment for object explorer, query pane and activity monitor

  • May 04 / 2010
  • 0
DBA best practices, dbDigger, SSMS tips and tricks

Customize SSMS startup environment for object explorer, query pane and activity monitor

After launching SQL Server Management Studio (SSMS) you always modify the environment by opening query pane or by opening/closing the object explorer. In SSMS i am also habitual to use activity monitor. Fortunately SSMS provides you option to modify the start up environment. At start up you can configure SSMS to open

  • empty environment
  • object explorer
  • query pane
  • both object explorer and query pane at same time
  • In SSMS 2008 open object explorer and activity monitor at same time

To configure your SSMS start up environment. Just go to Options in tools menu.

Open Options in SSMS

Now open ‘At start’ drop down list in produced options frame. It is under ‘General’ heading as marked in snap below.

Configure SSMS startup options

Select required environment and click Ok to save the settings. Next time when you would open SSMS you have your required environment there. Activity monitor of SSMS 2008 can be used with SQL Server 2005 instance.

Consult us to explore the Databases. Contact us