title: SQL Trigger does not work
body: <p>Are there any conditions in which a Trigger is not fired?</p>
  
  <p>We have this situation: </p>
  
  <p>We have a table and there are rows that are been deleted. We need to know who and/or when these row are deleted.</p>
  
  <p>We create this trigger: </p>
  
  <pre><code>ALTER TRIGGER [dbo].[AUDITdel_nit] ON [dbo].[Client]
   FOR DELETE
   AS
   Insert into AUDIT select 'Delete', getdate(), 'Row Deleted', SYSTEM_USER, host_name(),
   (select 'ID Client: ' + convert(varchar(12),Id)  from deleted), 'Client' ,APP_NAME()
  </code></pre>
  
  <p>We made some test: deleting rows via stored procedures and the deleted rows appears in our AUDIT table.</p>
  
  <p>But suddenly today we found a row deleted that does not appear in the AUDIT table...</p>
  
  <p>Any idea what could be wrong?</p>