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