abt trigger

<i><b>Originally posted by : Nitesh (friend_nitesh@rediffmail.com)</b></i><br /><br />how can i update a trigger<br />or<br />how can i view name of all trigger created by me<br /><br /><br />

<i><b>Originally posted by : abul</b></i><br />Trigger is a special type of Stored Procedure.<br /><br />SP_HelpText <TriggerName/Stored Proc Name>