I would like to create a trigger in a SQL 2005 database to run a table update script that I have created. I would like the trigger to execute my update script whenever data is inserted or updated into the table. It should not be very complicated.
Could someone please share with me the syntax on how to create such a trigger? I'd be grateful.