October 12, 2005 at 10:15 am
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?
October 12, 2005 at 11:26 am
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.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy