Both in SQL Server management studio (SSMS) 2005 and 2008 have option to select from objects like object explorer, new query window or activity monitor to be opened automatically when SSMS starts. Following following couple of steps for this start up customization of SSMS
- Go to ‘options’ in tools menu
- Click on ‘environment’ in left frame (if not already selected)
- Open drop down list in front to ‘At startup’
- Now choose your required objects and click ok
Now whenever you will open SSMS, the panes or explorer that you choose would be available automatically. If you choose ‘Open empty environment’ then you would get nothing at SSMS start up, but just SSMS frame without any login frame or any thing else.
Note: The options in drop down may differ slightly in SSMS 2005 and 2008.