Home Forums SQL Server 2012 SQL 2012 - General SSMS Scripting disable trigger? RE: SSMS Scripting disable trigger?
Venkataraman R
SSChasing Mays
Points: 634
More actions
October 28, 2013 at 6:50 am
#1661937
You can disable trigger using "Disable" FROM Context menu of a trigger in SSMS object explorer. But, you cannot script "DISABLE TRIGGER" from SSMS. You will be able to Script out CREATE, ALTER, DROP etc. but not DISABLE.