SQL 2005 Enterprise Manager Equivalent?

[Joeybear23]

I am very much accustomed to SQL 2000 Enterprise Manager, and have been awkwardly fumbling my way around the 2005 Management Studio. I do not like how you have to physically connect to each server before you can browse through the server settings, jobs, error logs, etc. With 2000 EM, you have a list that the console connects to automatically with saved credentials, and it is much less time-consuming. I have 30+ SQL Servers that I check on a regular basis, and having to manually connect to each one before being able to click throughthem is tiresome.

Am I missing something?

SQL/SAP DBA

 

[SQLBill]

Am I missing something?

Nope. Don't know why Microsoft designed it that way...but that's how it is.

-SQLBill

Posting advice: FAQ481-4875

 

[ptheriault]

You can Register you servers with SSMS. If you click on the View menu at the top of SSMS and select Registered Servers.
You can then register your servers and save you connection info. You will get a split screen view on the left side of the page. The top part will be registered servers and the bottom will be the object explorer. Once you've registered your server you can right click on it and connect to QA or Object Explorer.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[Joeybear23]

Yeah, I have them all registered with SSMS, but that only gives me an on/off status. To browse through them, I have to double-click on each one and then browse through. That wouldn't be a problem, except while in the object explorer none of the registered server structure is gone (groups, etc) and all I get is a list of the servers in the order in which I double-clicked on them. It is a disorganized mess.

SQL/SAP DBA

 

[ptheriault]

That is correct. I don't like it much either. I used to have all my servers broken out into groups by application. Not anymore.

- Paul
- If at first you don't succeed, find out if the loser gets anything.