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,, 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)