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.
Now open ‘At start’ drop down list in produced options frame. It is under ‘General’ heading as marked in snap below.
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.