Trigger to insert rows in Remote table

anirbanbasuz · August 24th, 2006, 03:02 AM

Hi,

I have a requirement where I have to insert the same row being added to one of my table in a table to another table in a remote location on a separate database itself. I need to do this using a trigger.

Can anybody tell whether this is possible or not? And if possible, how?

Regards,
Anirban

harsh_athalye · August 25th, 2006, 06:02 AM

Is the remote server you are trying to add row to is a linked server ?

If it is then you can insert row using four-part name syntax like this

Code:

Insert into server.database.owner.table(col1, col2,...)
values(....)

Harsh Athalye
India
"Nothing is impossible"