Results 1 to 7 of 7

Thread: 7.0 Server to run a LOAD DATABASE on a 6.5 Server

  1. #1
    Guest

    7.0 Server to run a LOAD DATABASE on a 6.5 Server

    I want to schedule a job on a 7.0 Server, which could run a LOAD DATABASE on a 6.5 Server. Anyone know a way to do this?

  2. #2
    Ray Miao Guest

    7.0 Server to run a LOAD DATABASE on a 6.5 Server (reply)

    Can't do.


    ------------
    at 3/27/00 11:33:23 AM

    I want to schedule a job on a 7.0 Server, which could run a LOAD DATABASE on a 6.5 Server. Anyone know a way to do this?

  3. #3
    Guest

    7.0 Server to run a LOAD DATABASE on a 6.5 Server (reply)

    Ray,

    On what do you base this assertion?


    ------------
    Ray Miao at 3/27/00 11:50:44 AM

    Can't do.


    ------------
    at 3/27/00 11:33:23 AM

    I want to schedule a job on a 7.0 Server, which could run a LOAD DATABASE on a 6.5 Server. Anyone know a way to do this?

  4. #4
    Ray Miao Guest

    7.0 Server to run a LOAD DATABASE on a 6.5 Server (reply)

    You can do this between sql7 servers only. Read more before post.


    ------------
    at 3/27/00 1:33:38 PM

    Ray,

    On what do you base this assertion?


    ------------
    Ray Miao at 3/27/00 11:50:44 AM

    Can't do.


    ------------
    at 3/27/00 11:33:23 AM

    I want to schedule a job on a 7.0 Server, which could run a LOAD DATABASE on a 6.5 Server. Anyone know a way to do this?

  5. #5
    Guest

    7.0 Server to run a LOAD DATABASE on a 6.5 Server (reply)

    I researched this in BOL before I posted, but found nothing on this particular situation. Can you direct me toward the appropriate documentation?


    ------------
    Ray Miao at 3/27/00 1:47:36 PM

    You can do this between sql7 servers only. Read more before post.


    ------------
    at 3/27/00 1:33:38 PM

    Ray,

    On what do you base this assertion?


    ------------
    Ray Miao at 3/27/00 11:50:44 AM

    Can't do.


    ------------
    at 3/27/00 11:33:23 AM

    I want to schedule a job on a 7.0 Server, which could run a LOAD DATABASE on a 6.5 Server. Anyone know a way to do this?

  6. #6
    Guest

    7.0 Server to run a LOAD DATABASE on a 6.5 Server (reply)

    Hey Ray, guess what?

    I did it. Here's how.

    I wrote a stored procedure on the 6.5 side to do the LOAD DATABASE. On the 7.0 side, I linked to the 6.5 server. In the job, scheduled on the 7.0 side, I just executed the stored procedure with a fully qualified stored procedure name. Cool, huh? Perhaps you should THINK a little more before YOU post.




    ------------
    Ray Miao at 3/27/00 1:47:36 PM

    You can do this between sql7 servers only. Read more before post.


    ------------
    at 3/27/00 1:33:38 PM

    Ray,

    On what do you base this assertion?


    ------------
    Ray Miao at 3/27/00 11:50:44 AM

    Can't do.


    ------------
    at 3/27/00 11:33:23 AM

    I want to schedule a job on a 7.0 Server, which could run a LOAD DATABASE on a 6.5 Server. Anyone know a way to do this?

  7. #7
    Guest

    7.0 Server to run a LOAD DATABASE on a 6.5 Server (reply)

    This reminds me of a Dilbert strip....with all due respect to Ray, since he's posts answers to many questions on this board.

    Pointy Haired Boss (to Dilbert): I studied your technical recommendation and decided it's impossible.
    Dilbert: I already did it.
    PHB: It will never work.
    D: It's working perfectly.
    PHB: You spelled this word wrong.
    D: That's a number.

    Ray, I know you're not a PHB. Keep up the good work.

    ------------
    at 3/27/00 5:46:51 PM

    Hey Ray, guess what?

    I did it. Here's how.

    I wrote a stored procedure on the 6.5 side to do the LOAD DATABASE. On the 7.0 side, I linked to the 6.5 server. In the job, scheduled on the 7.0 side, I just executed the stored procedure with a fully qualified stored procedure name. Cool, huh? Perhaps you should THINK a little more before YOU post.




    ------------
    Ray Miao at 3/27/00 1:47:36 PM

    You can do this between sql7 servers only. Read more before post.


    ------------
    at 3/27/00 1:33:38 PM

    Ray,

    On what do you base this assertion?


    ------------
    Ray Miao at 3/27/00 11:50:44 AM

    Can't do.


    ------------
    at 3/27/00 11:33:23 AM

    I want to schedule a job on a 7.0 Server, which could run a LOAD DATABASE on a 6.5 Server. Anyone know a way to do this?

Posting Permissions

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