-
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?
-
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?
-
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?
-
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?
-
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?
-
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.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
-
Forum Rules
|
|