I'm attempting to create an after trigger that will update a second table with the information I entered in the first table. Any expertise shared would be appreciated.

CREATE TRIGGER trigger_fun1

ON tablename

FOR AFTER

UPDATE

WITH APPEND

AS

"COULD YOU HELP"

If both tables are identical , just

Insert into table2 select * from inserted

else , the usual

Insert into table2 (field1,field2...)  select (field1,field2...) from inserted

---

Hey , sysadm , leave the users alone
They are nothing more
than another brick in the firewall