Triggering a table in OLTP system problem

Asked By quimbry 0 points N/A Posted on - 11/08/2011

Hello there!

Can you help me…

I have implemented a trigger on a table in the OLTP system which instantiate a COM object and pass the inserted row for processing. Can this be implemented in a better way?

Please guide me on this…

Thank you…

• Status: Open
• Question Views: 810
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Software

Answered By Thompson Locker 10 points N/A #107484

Triggering a table in OLTP system problem

In case you are able to add triggers, then you will possibly solve the problem that you are having. All you need to do is capture before and after, or you capture just after images and then put them into a simple flat table and use that as your source. As an  alternative to doing the same, you can also choose to use the database logs,  which may be a bit more complicated, but that will entirely  depend on the kind of tools that you are using.

Another thing to note is that when using triggers (basically the update, insert and delete functions), you will note that you will have avoided the need for the 'check for changes' bit, and that is because all changes will be captured automatically.

Regards
Thompson Locker

 

About Thompson Locker

Questions
0

Answers
619

Best Answers
77

• Vote Up 0 Vote Down

• Posted on - 12/17/2011
• Question Category: Misc Software