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
- 5256 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
Does group by or order by come first?
How to get a list of columns in a view using the "sp_columns" stored procedure?
How do I open a .db file?
How to make a column nullable?
Do you know sql server 2008 backup compression?
What is SubQuery in SQL Server 2008
What is a covered index?
Name few of the dcl commands in sql?
How to sort the query output with order by clauses in ms sql server?
How to retrieve error messages using odbc_errormsg()?
What are the purposes and advantages stored procedure?
Explain the rules for designing files and file groups in sql server?
What do you know about normalization and de- normalization?
What do you understand by hotfixes and patches in sql server?
Is t sql the same as sql server?
