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
- 4134 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
What is an indexed view?
How to list all stored procedures in the current database using ms sql server?
What is difference between order by and group by?
What are the new data types are introduced in sql 2000?
explain different types of backups avaialabe in sql server? : Sql server database administration
what is the Ticketing tool used in Wipro technologies at Bangalore...???
 Explain what is sql override for a source taLle in a mapping?
What is precedence constraint?
How to list all login names on the ms sql server?
What are different types of raid configurations? : SQL Server Architecture
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What is ms sql server reporting services?
What is nonclustered index with included columns ?
What is schemabinding a view?
How do you create a clustered index?
