Hai,

I am using SQL Server.

In any database server, it will take care of log file. But I am in such a situation, I have to create my own log file. For this I can create a general procedure which will take care of creating my log file and this stored proc I have call from each and every table for which I have to maintain the log.

But my question is Is there any way I call this stored proc when ever any record deletion takes place in the database, will record the information into my log file? (I will create list of tables for which this log file is to be updated).

So I want a database trigger that will fire on deletion of record from any table in the database.

Can anybody Help me in this regard.

Thanks in Advance.