Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    Join Date
    Feb 2004
    Location
    So. Cal
    Posts
    4

    Unanswered: 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!

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    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.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    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
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I can sell you one. $899 with a professional discount

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    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.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  6. #6
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    And more accurately, you must have the same version and SP level (MDAC is controlled by service pack on both client and server.)

  7. #7
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    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
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  8. #8
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    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...

  9. #9
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Marlboro Red?

    Here ya go.....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  10. #10
    Join Date
    Feb 2004
    Location
    So. Cal
    Posts
    4
    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.

  11. #11
    Join Date
    Feb 2004
    Location
    So. Cal
    Posts
    4
    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.

  12. #12
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    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.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  13. #13
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Hey Satya, you're ruining my perfect sale opportunity, I need money for Nicorette!!!

  14. #14
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Originally posted by rdjabarov
    Hey Satya, you're ruining my perfect sale opportunity, I need money for Nicorette!!!
    Don't worry.... I will not
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  15. #15
    Join Date
    Feb 2004
    Location
    So. Cal
    Posts
    4
    Originally posted by Satya
    Whereabouts you're based, I can lend you Ver.7 tools.
    Riverside, CA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •