In order to avoid executing trigger, without disabled the trigger, on some table that you want to make some UDL operations, for example, execute script that update some fields in the table, there is away to do it.
on the script you have to add
Set context_Info 0x1256698456
this will write context_info value in master.dbo.sysprocesses, then all the following execution sentences can be captured by the trigger, by using this code:
------- do nothing from batch
declare @BinVar varbinary(128)
Select @BinVar = context_info from master.dbo.sysprocesses where spid = @@SPID
if @BinVar = 0x1256698456 return