Steven Mann (10/2/2008)

---

In my environment I have 20 databases that are constantly updated 24 hours a day. The application uses one user account so my question has two parts.

1. Can I exclude this user from the trigger?

2. With changes being made constantly is there a way to keep the table size down?

SET @loginname = @data.value('(/EVENT_INSTANCE/LoginName)[1]',
    'NVARCHAR(100)')
....

IF @loginname != 'appuser'
BEGIN
    -- do the work
END