Queries

• BhanuRawal

  Newbie

  Points: 7

  More actions

  November 16, 2003 at 11:34 pm

  #84741

  How can i explicitly execute a trigger ?

  Tigger gets executed when an event like Insert/Delete/Update is executed...i need to fire a trigger from Stored Procedure without executing an insert/delete/update statement

  How can i do this ?

• Sachin Dedhia

  SSCrazy

  Points: 2104

  More actions

  November 17, 2003 at 6:38 am

  #482194

  I wonder what is that u want to do in a trigger on a table without executing Insert/Delete/Update queries???

  What u can do is write a stored procedure and call this sp from the trigger and/or another sp. (I guess u r not using the inserted and deleted tables in the trigger)

  Sachin

  
  

  Regards,
  Sachin Dedhia

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 17, 2003 at 7:01 am

  #482202

  What are you trying to do?

  Frank

  http://www.insidesql.de

  http://www.familienzirkus.de

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]