Trigger fire on commit

Posted on 2006-05-26
Medium Priority
Last Modified: 2008-02-26
Hi folks

Is there any way to get a trigger to fire on commit instead of firing on every insert statement ?

I would like the INSERTED table to contain all the records affected by the (transaction on that table). My program saves a tree of records and then the trigger has to manipulate the tree in various ways, and to have the trigger fire once for every record in the tree when I only want it to act once for the tree seems a waste !

I suspect a no answer but just thought I'd ask. I will increase points if "appropriate"
Question by:plq
LVL 75

Accepted Solution

Aneesh Retnakaran earned 500 total points
ID: 16770242
better u try it with an sp

Author Comment

ID: 16770317
Of course! thanks

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question