﻿DECLARE @sql nvarchar(max) = N''
SELECT @sql += N'DROP TRIGGER ' + name + char(13) + char(10) FROM sys.triggers WHERE name LIKE N'%asyncAudit%'

EXEC sp_executesql @sql
GO