Need SQL 7 Enterprise Manager

Does anyone know where I can get a copy of Enterprise Manager? I have the trial copy of 2000, but I need to administer data on a SQL 7 server, and I cannot create stored procedures, add users, or create DTS packages in 2000 that will work on SQL 7.
Thanks!You should install client tools for ver.7 to accomplish that task. May borrow CD from a friend or SQL homepage and go thru support for a valid link.|||SQL 2000 Client side tools will admin both SQL 2k and SQL 7...

AND you can buy a developer addition for US$49 directly from M$...

It's a full blow Enterprise edition as well, including the tools...

Good Luck|||I can sell you one. $899 with a professional discount ;)|||If you create DTS packages using SQL 2K EM it will not work on SQL 7 server. You must have similar MDAC when you design DTS.|||And more accurately, you must have the same version and SP level (MDAC is controlled by service pack on both client and server.)|||Originally posted by Satya
If you create DTS packages using SQL 2K EM it will not work on SQL 7 server. You must have similar MDAC when you design DTS.

What are you guys talking about?

I just did it...do you mean as a scheduled package?

I'm confused...|||Brett,

You CAN create and interactively execute a package using SQL2K client tools on any server. When you do it on SQL7, no server-initiated execution of this package will succeed. If you do it on a SQL2K server with lower SP than your client's machine, the result will be the same as with SQL7. The only time it will yield a successful execution will be when the server's SP level is the same or higher than your client's.

...man, I need a cigarette to catch my breath here...|||Marlboro Red?

Here ya go....|||Originally posted by Satya
You should install client tools for ver.7 to accomplish that task. May borrow CD from a friend or SQL homepage and go thru support for a valid link.
Unfortunately, I can't find anyone who has the CD. I looked on MS website, but couldn't seem to get to anything about SQL 7. Where is the SQL homepage?
Thanks for your help.|||Originally posted by rdjabarov
Brett,

You CAN create and interactively execute a package using SQL2K client tools on any server. When you do it on SQL7, no server-initiated execution of this package will succeed. If you do it on a SQL2K server with lower SP than your client's machine, the result will be the same as with SQL7. The only time it will yield a successful execution will be when the server's SP level is the same or higher than your client's.

...man, I need a cigarette to catch my breath here...

Brett,
This is what I found out - you can create and execute the package manually using EM 2K, but it will not run on a 7.0 scheduler. Also, you can't get in to add users, which, at this point is what I really need to do. And if you open a package you created in 7.0 and save it from 2K, it won't work anymore.|||Whereabouts you're based, I can lend you Ver.7 tools.

Originally posted by dmuller
Unfortunately, I can't find anyone who has the CD. I looked on MS website, but couldn't seem to get to anything about SQL 7. Where is the SQL homepage?
Thanks for your help.|||Hey Satya, you're ruining my perfect sale opportunity, I need money for Nicorette!!!|||Originally posted by rdjabarov
Hey Satya, you're ruining my perfect sale opportunity, I need money for Nicorette!!!

:eek: :eek: Don't worry... I will not :p|||Originally posted by Satya
Whereabouts you're based, I can lend you Ver.7 tools.
Riverside, CA|||Originally posted by rdjabarov
I can sell you one. $899 with a professional discount ;)

Be rational... and help others...