hi can any one tell me which is a better option for a multiuser ,remote database Performance wise........Trigger ,Stored Procedure,OR transaction ......
I have to find an architecture for audit trail..........
Poojagolechha

Hi

look up the following Link!

http://dbforums.com/arch/57/2003/8/866313

If by "audit trail" you mean tracking inserts, updates and deletes on a table then triggers are the obvious choice. The triggers would likely call a stored procedure that handles the common code.

Unless of course your DBMS has a built-in way of auditing that doesn't require you to write your own code.

Better than what? Aside from that, which database engine (DB2, MS-SQL, MySQL, Oracle, etc) are you using now?

-PatP