How can we help you today? How can we help you today?

Ignore triggers with certain text in name

Is there a way to ignore triggers with certain text in the name? In my case it's ApexSQLAudit and these are the types of triggers:

CREATE TRIGGER [dbo].[dbo_Autopayment_ApexSQLAudit_Delete] ON [dbo].[Autopayment]
WITH EXECUTE AS CALLER
FOR DELETE
AS EXTERNAL NAME [ApexSQL.Audit.BeforeAfter.MOBILECRM.dbo.Autopayment.Delete].[ApexSQL.Audit.BeforeAfterClr.BeforeAfterTrigger].[Delete]
GO
CREATE TRIGGER [dbo].[dbo_Autopayment_ApexSQLAudit_Insert] ON [dbo].[Autopayment]
WITH EXECUTE AS CALLER
FOR INSERT
AS EXTERNAL NAME [ApexSQL.Audit.BeforeAfter.MOBILECRM.dbo.Autopayment.Insert].[ApexSQL.Audit.BeforeAfterClr.BeforeAfterTrigger].[Insert]
GO
CREATE TRIGGER [dbo].[dbo_Autopayment_ApexSQLAudit_Update] ON [dbo].[Autopayment]
WITH EXECUTE AS CALLER
FOR UPDATE
AS EXTERNAL NAME [ApexSQL.Audit.BeforeAfter.MOBILECRM.dbo.Autopayment.Update].[ApexSQL.Audit.BeforeAfterClr.BeforeAfterTrigger].[Update]
GO



NeilN1
0

Comments

3 comments

Sort by
  • Dan_J
    Hi @NeilN1

    Thanks for reaching out to us regarding this!

    Aside from the comparison options to ignore triggers, there is no way to filter out triggers with certain text/characters in the name from the comparison process.  

     

    It is however possible to apply filters after the comparison process is complete to stop certain triggers from being deployed:



    Dan_J
    0
  • NeilN1
    This won't work for us as every table will still come up as different and trigger a review.  Appreciate the reply, though.
    NeilN1
    0
  • Dan_J
    Hi @NeilN1

    No problem at all.  I'm sorry these options won't work in your case.
    Dan_J
    0

Add comment

Please sign in to leave a comment.