Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > SQL Language
|
SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 24th, 2006, 03:02 AM
Registered User
 
Join Date: Nov 2004
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to anirbanbasuz
Default Trigger to insert rows in Remote table

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
 
Old August 25th, 2006, 06:02 AM
Registered User
 
Join Date: Aug 2006
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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"





Similar Threads
Thread Thread Starter Forum Replies Last Post
Trigger : after update insert into second table ik SQL Server 2000 4 January 30th, 2009 12:32 AM
INSERT multiple rows to a table nvillare Oracle 7 November 3rd, 2007 04:47 AM
trigger to insert current date on insert kev_79 SQL Server 2000 3 January 23rd, 2006 05:58 PM
insert rows into the same table nik SQL Server 2000 1 October 26th, 2005 07:28 AM
Insert Trigger Arsi SQL Server 2000 2 February 25th, 2005 05:41 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.