Management Studio Object Explorer When First Launching

[theoryofben]

I feel like this shouldn't be so difficult. But how can I have SQL Server Management Studio open with my servers already connected in the object explorer?

I was able to do this in Enterprise Manager. But I can't seem to do it in SSMS.

Thanks


________________________________________________
[sub]"I have not failed. I've just found 10,000 ways that won't work."-Thomas Edison[/sub]

 

[mrdenny]

You can't and you don't what to do that. Each connection from object explored takes resources on the server which you probably don't want to waste. Also you don't want to sped all that time waiting for ssms to connect to each server.

Look at the registered servers option under the view menu. That'll show you all the servers, and their state without actually connecting to the SQL instance.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Blog

 

[djj55]

mrdenny has a good point about resources.

That being said you can have one instance attached by using the -S command line switch in your shortcut.

My Shortcut Target: looks like[tt]
"C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe" -E -S MyComputer\MyInstance[/tt]

Mine points to my local server so I am not concerned about resources.

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!