1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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?

Question Posted / swapna


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

how to retrive only second row from table in sql server 2000?

15 Answers   Cognizant, CTS,

How to insert new line characters into strings?

0 Answers  

What is a Stored Procedure?

8 Answers  

Is it possible to create tables in stored procedures using a variable for the table name?

2 Answers  

How to avoid cursors?

3 Answers   CarrizalSoft Technologies, HP,




How you can get a list of all the table constraints in a database? : Sql server administration

0 Answers  

What happens if null values are involved in boolean operations?

0 Answers  

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 Answers  

Does sql server use java?

0 Answers  

wat will be the sql query to extract only last 3 records from table supose table hving thousands for records

19 Answers  

When would you use a before or after trigger?

0 Answers  

What is Index ? Explain its Types?

2 Answers   ADP,

For more SQL Server Interview Questions Click Here
Categories