Post reply

How to call a stored procedure in sql server 2005 from sql server 2000

  • February 25, 2009 at 1:30 pm

    #200227

    Hi,

    I need set up a job in sql server 2000 machine, which calls/executes stored procedures in sql server 2005 machine. The part of the job on sql server 2000 machine is, it calls exe on that machine and then executes stored proc on sql server 2005 machine...

    Can we use sqmcmd in sql server 2000, I think it is a sqk server 2005 tool right ?

    Thanks forthe advice..

    -VG

  • February 25, 2009 at 1:35 pm

    #950254

    You might care to look at OPENQUERY over a linked server connection. OPENQUERY will "send" the execution to the remote 2005 server, and bring back the output.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • February 25, 2009 at 2:11 pm

    #950273

    Thanks Matt..

    Is there any other options like using command line utilities...

    Thanks again..

    -VG

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply