 <p>You need to loop through all the deleted records using a cursor. Here is an example of a trigger that does this :</p> <pre><code>CREATE trigger TR_AspNetUsers_AD on dbo.AspNetUsers for delete as begin -- always do this in triggers set nocount on --trigger specific variables declare @AspNetUsersID int declare crDeleted_AspNetUsers Cursor local fast_forward for select d.AspNetUsersID from deleted d --if there was one or more deletes... open crDeleted_AspNetUsers fetch next from crDeleted_AspNetUsers into @AspNetUsersID while @@FETCH_STATUS = 0 begin --do here whatever you need when deletes have occured... fetch next from crDeleted_AspNetUsers into @AspNetUsersID end close crDeleted_AspNetUsers deallocate crDeleted_AspNetUsers end; </code></pre> <p>All you need to do is adapt it to your needs.</p>