Find hidden triggers in database

anuragshrivastava64

I am new to SQL Server.
I have got a project where lot of stored procedures ,UDF's and triggers are used.
The problem is I am finding all the functions and procedures but not been able to find any of the TRIGGERS.
Can anyone plz tell me where can I find the triggers.

I used the query (Select * from Sysobjects) and it shows 52 triggers

ck9663

Expand|Select|Wrap|Line Numbers

select * from sysobjects where xtype = 'TR'

then you go

Expand|Select|Wrap|Line Numbers

sp_helptext <trigger_name>

-- CK

Find hidden triggers in database

Post your reply

Similar topics

Question stats

	Ask Question
Home Questions Articles Browse Topics Latest Top Members FAQ