title: delete trigger not working
body: <p>I have a delete trigger on a table in my DB that is supposed to be inserting rows into an "audit" table, but when I delete rows from the trigger table, they do not show up in the audit table. I have insert and update triggers following this same format that work fine but I can't seem to get this one to work. Here is the trigger:</p>
  
  <pre><code>USE [OutageDev]
  GO
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  ALTER TRIGGER [dbo].[tr_audOutageSummaryDelete]
  ON [dbo].[Outage Summary]
  AFTER DELETE
  AS
    BEGIN
        -- SET NOCOUNT ON added to prevent extra result sets from
        -- interfering with SELECT statements.
        SET NOCOUNT ON;
  
        INSERT INTO dbo.[Outage Summary Audit]
                    (OutageSummaryID,
                     Dispatcher,
                     /*Removed columns for brevity*/
                     StateEmergency,
                     Comment,
                     AuditDateTime,
                     AuditUser,
                     AuditAction)
        SELECT d.OutageSummaryID,
               d.Dispatcher,
               /*Removed columns for brevity*/
               d.StateEmergency,
               t.Comment,
               GETDATE(),
               SUSER_SNAME(),
               'DELETE'
        FROM   deleted d
               JOIN [Outage Summary] t
                 ON d.OutageSummaryID = t.OutageSummaryID
    END 
  </code></pre>