There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better?






There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is wri..

Answer / swapna

Instantiating COM objects is a time consuming process and
since you are doing it from within a trigger, it slows down
the data insertion process. Same is the case with sending
emails from triggers.


This scenario can be better implemented by logging all the
necessary data into a separate table, and have a job which
periodically checks this table and does the needful.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer




More SQL Server Interview Questions

What is Self Join?

4 Answers  


What are the recovery models for a database?

0 Answers  


What is a View ? Can we insert, Update and delete a view?

0 Answers   Arigo Infotech,


what is isolation level at dead lock?

0 Answers   Verizon,


how many no of arguments can be passed in procedures and functions

1 Answers   ABC,






What is the basic difference between clustered and a non-clustered index?

9 Answers   Infogain,


two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?

5 Answers   CSE,


Diffrences between sql server 2000 vs 2008

0 Answers   TCS,


How to call a function from a stored procedure in SQL Server ?

0 Answers   HCL,


How many types of indexes are there in SQL Server?

6 Answers   United Healthcare, CarrizalSoft Technologies,


ow to bring suspect mode datbase online from scratch

0 Answers  


What is the New in SQL server 2008?

0 Answers  






Categories