Post reply

updating data in different SQL Server Database w/o using linked server

  • December 28, 2005 at 7:30 pm

    #103007

    Hello im making a Stored Procedure that will access and update data on different server. I've already retrieve data using the OPENROWSET but the problem is i need to update the status column of the retrieved data.

    Can anybody have a way on updating the data on another server without using linked server


    cabby

  • December 28, 2005 at 7:36 pm

    #611831

    As you're already using OPENROWSET, take a look at OPENDATASOURCE.

     

    --------------------
    Colt 45 - the original point and click interface

  • December 28, 2005 at 8:25 pm

    #611839

    Tnx Phil,

    I've already made some test and it works. It really is a big help now im using 1 connection in my program and my stored procedure is the one connecting to the different server. i've tried also the OPENROWSET as the same syntax i made in the OPENDATASOURCE and it works also

    tnx alot


    cabby

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

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