Thursday, June 20, 2013

Unable to see triggers in SSMS


Unable to find triggers in SSMS ?

Below query helps to identify whether triggers are there or not 

SELECT so.name, st.name, st.type FROM sys.triggers st LEFT OUTER join sys.objects so
ON st.parent_id = so.object_id AND st.is_ms_shipped =0 

Later we need to expand Databases - Tables - Triggers (you will be able to see triggers in this path)