Hi all,
I have written a stored procedure that transfers, validates and transforms data from one database to another on a nightly basis. It is used for interfacing to another application.
The movement of data will be quite heavy using this SP.

I need to incorporate logging in to this SP.

What do you suggest, should i directly write to a log file, or should i first insert in to a log table in the database.
Please suggest which is better.