triggers and inserted table

• Tudor Gabriel

  Mr or Mrs. 500

  Points: 533

  More actions

  October 12, 2005 at 10:15 am

  #166400

  in an "after insert" trigger im trying to make a cursor(i know its not wise and very slow, but its a must) for a select from INSERTED. I doesnt work, @@FETCH_STATE is always-1 after a fetch.

   

  i tried to make a table variable, insert into it all the values from inserted table and it works. the problem is that i need to make this trigger a fast one, and an aditional insert into a table variable will slow it down. am i doing something wrong with the insert table?

   

  and is there any way to temporary disable a trigger? i have some time taking procedures and i dont want to make them to start the trigger. i need it somehow disabled for the curent transaction. is there any way to do this?

• Phil Parkin

  SSC Guru

  Points: 247172

  More actions

  October 12, 2005 at 11:26 am

  #596891

  No enough info.  Please post the code for your trigger.  There are some clever people on this site and the cursor may not be necessary after all.

  To disable a trigger, check out ALTER TABLE / DISABLE TRIGGER in BOL.

  ---