[This topic is migrated from our old forums. The original author name has been removed] [Attachment has been removed.]
If you disable a SQL Server 2008 trigger via the DISABLE TRIGGER command, there is no indication in the user interface that the trigger is not active.
The icon for a disabled trigger is the same as an active one and there is no indication of the trigger's status in the Info tab.
See the attached screenshots for more info.
The first shows the result of creating a test database with a table (foo) and a trigger (mangle_new_data) then reconnecting to the database and expanding the trigger icon.
The second shows the result of disabling the mangle_new_data trigger then reconnecting to the database and expanding the trigger icon.
The third shows the information presented in the Info tab for the mangle_new_data trigger after it was disabled.