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
- 4202 Views
- 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
How to create a scrollable cursor with the scroll option?
do you know how to configure db2 side of the application? : Sql server database administration
What is the process of normalising?
What is data source in connection string?
What is data modification?
Explain the use of containers in ssis and also their types?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
Is null in sql server?
How do you create type- insensitive operator?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
What happens if ntwdblib.dll is missing on your machine?
How do you know if sql server is running on your local system?
What is the recovery model?
What is the difference between NOROW and LOCKROW?
What is policy management?
