Trigger Problem

• sifan

  SSC Enthusiast

  Points: 148

  More actions

  December 18, 2003 at 10:05 pm

  #83727

  I have created a trigger using SQL Query Analyser. For modification I open SQL Enterprises Manager and went to Stored procedures node There, I can not find the trigger.

  What should be the problem? or How can I modify the trigger as which we modify Stored Procedures.

  Please help me.

  Thank you all

  Shifan

  qaqa

  
  qaqa

• winash

  SSChampion

  Points: 11446

  More actions

  December 19, 2003 at 12:55 am

  #487149

  Hi Shifan,

  To modify the trigger --

  Open SQL Enterprise Manager

  Right click on the table on which the trigger has been created

  Select the 'All Tasks' menu option and then the 'Manage Triggers' option

  In the drop down box at the top of this screen you should see your trigger

  or you could go to Query Analyser and execute

  sp_help <TriggerName> to view the trigger code which can then be altered in QA by changing the CREATE TRIGGER to ALTER TRIGGER

  HTH

• kokyan

  SSCommitted

  Points: 1694

  More actions

  December 19, 2003 at 2:53 am

  #487168

  You can just go to Query Analyzer and go the table which have the trigger. Expand the "tree" and you should see "Triggers". Expand more of the "tree" and you can see all the triggers that you created. Right click of the trigger and click "Edit". You can do any modification to the trigger and execute it.

  Regards,

  kokyan

  
  
  Regards,
  kokyan