我不认为它可能。触发器在更新，插入或删除期间自动启动。但是，您可以验证触发器的可用性状态，如下所示：

I don't think its possible. Triggers automatically initiate during update, insert or delete. But, you can validate the availability status of trigger as below:

select * from dbo.sysobjects
where name = 'MyTrigger' and OBJECTPROPERTY(id, 'IsTrigger')