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
- 5337 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 are the different types of backups avaialabe in sql server 2005?
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
What is etl - extraction, transformation, and loading?
How do use Having,Group by,Group function in SQL?
What is the maximum size of a row in sql server?
How to define output parameters in stored procedures?
What are the different normalization forms?
Why I have to use stored procedures?
What is the difference between DATETIME2 and DATETIME?
What is query parameter in ssrs?
How you trouble shoot when any job fails
How can I check that whether automatic statistic update is enabled or not?
Explain how to maintain a fill factor in existing indexes?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What is the filtered index?
