I use this ( this is home cooked)

create proc temp_slowDelete

(

@table varchar(255),

@where varchar(1024)

)

as

/* Slow transaction friendly delete */

declare @ParmDefinition nvarchar(1024)

declare @deleteStatment nvarchar(2048)

declare @statment nvarchar(2048)

declare @total int

declare @rowcount int

Select @deleteStatment...