Insert into the Linked Database
Posted on 2004-09-28
I have an Sql Server database. I link this database to oracle database (I configure that using Enterprise Manager). Now, I want to write a trigger that insert any new inserted tuple in the oracle. I tried the following:
Create TRIGGER x ON [dbp].[MYTable]
INSERT INTO [Linke_Server].[DatabaseName].[Table] Values(col1.inserted,col2.inserted)
but it didn't work.. Some one tell me that I should use OpenQuery, but i don't know how to do that as insertion. Any idea??