467,134 Members | 968 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,134 developers. It's quick & easy.

Find hidden triggers in database

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
Sep 16 '08 #1
  • viewed: 3804
1 Reply
Expert 2GB
Expand|Select|Wrap|Line Numbers
  1. select * from sysobjects where xtype = 'TR'
then you go

Expand|Select|Wrap|Line Numbers
  1. sp_helptext <trigger_name>
-- CK
Sep 16 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

11 posts views Thread by raulgz | last post: by
1 post views Thread by tim.pascoe@cciw.ca | last post: by
4 posts views Thread by Mike | last post: by
27 posts views Thread by one man army | last post: by
7 posts views Thread by ajomara | last post: by
4 posts views Thread by --CELKO-- | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.