Post reply

Linked Server in SQL Server 2005

  • March 20, 2009 at 3:49 pm

    #129268

    Hi all,

    I am new to this forum and I am looking for some help regarding SQL Server Stored Procedure. I have to write a Stored procedure in SQL Server 2005 which will update some value in the Oracle Database 10g. This stored procedure will be triggered when the table in the sql server is updated. Also it will bring some value from oracle and update it in the Sql server.

    Please somebody help me with this.

    Thanks in advance.....

  • March 21, 2009 at 12:41 pm

    #964010

    Hi

    I did not yet connect to an Oracle via linked server. Because you did not explain special problems, try this (copied from BOL):

    EXEC sp_addlinkedserver

    @server = 'LONDON Mktg',

    @srvproduct = 'Oracle',

    @provider = 'MSDAORA',

    @datasrc = 'MyServer'

    GO

    See http://msdn.microsoft.com/en-us/library/ms190479.aspx.

    Is that what you are searching for or do you have any problems with?

    Greets

    Flo

  • March 21, 2009 at 2:25 pm

    #964018

    Thanks for replying....

    But I need some advice whether this can be done from stored procedure or T-Sql.....I know abt the linked server.....The stored procedure when triggered it will keep on checking the status of that updated record in oracle. If the status is updated in oracle it bring the new updated value from oracle to Sql server.....

    Thanks

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

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