启用：
disable trigger trigger_name
on {objectName | database_name | server};
禁用：
enable trigger trigger_name
on {objectName | database_name | server};
------------------------------------------------------------------------------------------------------------------------------------------
原文：http://www.cnblogs.com/JiangLe/p/4052903.html