How do you disable Server Objects Trigger in SSMS?
SQL Server 2005
Server Objects -> Triggers -> (right click on my logon trigger)
no properties...no disable trigger option...only script/reports/delete/refresh ?
I want to do this through the SSMS interface...I can't believe they don't have a point and click for "DISABLE TRIGGER .... ON ALL SERVER".
1. don't want the sql command...I know that....want SSMS interface.
2. dont want to disable DDL/DML database triggers or table triggers...I know that.
Thanks in advance.