Can someone please tell me how to write a trigger correctly.
I have been trying to write a trigger for about 2 weeks now that will fire when a field is updated in the database from an access form.
The trigger will work when I SET XACT_ABORT ON in the trigger but then the rest of the access application will not work. If I put SET XACT_ABORT OFF at the end of the trigger it will still not work. Any ideas on how I can rewrite this?
Create Trigger Consent_Date
SET XACT_ABORT ON
SET CONSENTDATE = inserted.dtmEligExpires
FROM BCSQL.dentrix.dbo.DDB_PAT_BASE AS DEN
INNER JOIN inserted ON DEN.CHART = inserted.strPatientid