I have a trigger to INSERT into an audit table. Looking a few months back, it seems that the trigger was working properly, but now it is creating 3 identical records. Here is what the trigger is doing:
ALTER TRIGGER [dbo].[trg_audit_member] ON [dbo].[Member]
SET NOCOUNT ON
Any idea why this is creating 3 records? I did an update through management studio and it created 3, as it does when something is done through the app.