How do I install SQL Enterprise Manager?

Hi All,

I'm pretty new to SQL anything... I'm wondering if there is a way to install just Enterprise Manager on my local workstation so I can open it up and manage or at least look at all of the SQL db's that are spread out on various servers - all in one place?

1. How can I install just Enterprise Manager (if possible). I ran setup on SQL2000 Personal Addition and it didn't look like it was going to get to a 'custom setup' screen so I cancelled, it looked like it was going to install SQL Server 2000 and all components (maybe this is what I have to do, I don't know).

2. If I install SQL2000 Enterprise Manager, am I able to access and view SQL 6.5 and SQL 7.0 and SQL 2000 databases all together?

Thanks so much.

Chris

You could install EM only with other client tools: the option is presented in the installer.

|||FYI Em does not support SQL 6.5 or SQL 2005, it does support 7 and 2000|||Thanks everyone! I found them.|||Where did you find them?|||

Just keep going through the install of SQL server and it will either bring you to a custom option (where you can choose just the utilities) or it will bring you to a page that you can check a radio button to just install the utilities.

|||Got it thanks!