Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 5273 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is the difference RDBMS and Graph Database?
Do you know what is a linked server in sql server?
What is transaction server implicit?
Explain Geometry datatype in sql server 2008 with example
In what three ways is the return statement used in a stored procedure?
Can We Use Data-grids For Our Report In Ssrs?
What is amo? : sql server analysis services, ssas
what are the three command line utilities and what are their primary functions?
Write a SQL queries on Self Join and Inner Join.
What is resultset concur_updatable?
What is efficiency data?
What is a Join and explain its types?
What is the use of sql profiler in sql server 2012?
What is order of B+tree?
Can sql servers linked to other servers?
