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
- 5186 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
Can you roll back the ddl statement in a trigger?
What will be the maximum number of index per table?
What are the advantages of sql azure?
How to create a view with data from multiple tables?
What you can do to delete a table without the delete trigger firing?
What is the xml datatype?
What are the extra roles available in msdb? : sql server security
How do I know if localdb is running?
What happens on checkpoint?
What is attribute? : sql server analysis services, ssas
What does asynchronous call backs means?
What is the difference between a primary key and a unique key? Are they the same?
What is format parameter in ssrs?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
Explain unique key in sql server?
