how to view trigger in sql 2005

[azad yadav]

hi friend How to view trigger so that we can modify, we donnot name of trigger. plz help me Thank and Regards Azad Yadav

[Eslam Afifi]

The management studio lets you view and modify triggers easily. If you want to scripts, use exec sp_helptext "Your_Trigger_Name" -- actually, any database object to view the trigger. And use Alter to modify the trigger.

Eslam Afifi

[anup keshari]

use this statement select * from sys.triggers which will return all the trggername list