Hello Everyone,

I am trying to create a trigger that will add or modify data in a table, every time a user adds or modifies data in another table. Any ideas would be greatly appreciate. Here is what I currently have:

-Two databses, call them DB1 and DB2.
-Two tables, each in one of the databases, call them DB1Tbl1 and DB2Tbl2.
-One column for each table, so DB1Tbl1Col1 and DB2Tbl2Col1.
-Every time a user adds or modifies data in DB1Tbl1Col1, this causes the same addition or modification in DB2Tbl2Col1.

I've written a trigger that does the INSERT part fine. It's the UPDATE part that's giving me problems. Here is the code as it now stands (without the UPDATE capability):

CREATE TRIGGER InsCol1Tbl1Tbl2Trig ON dbo.DB1Tbl1
FOR INSERT
AS
INSERT INTO dbo.DB2Tbl2 (DB2Tbl2Col1)
SELECT DB1Tbl1.DB1Tbl1Col1
FROM DB1Tbl1 INNER JOIN Inserted ON DB1Tbl1.DB1Tbl1Col1=Inserted.DB1Tbl1Col1;

Thanks.

Henry

you may consider not inserting into the table but instead update the table from table1 to table2

Create trigger "updatetables"
on db1.dbo.table1
for update, insert
not for replication
AS update db1.dbo.table1
set db1.dbo.table1.col1=db2.dbo.table2.col1
where db1.dbo.<table1.value> =db2.dbo.<table2.value>

if you are updating existing records use update if no go ahead with insert into. Is this for an audit table?

I hope this helps.