View Poll Results: How would you prefer to write logs from a stored procedure in SQLServer?
- 3. You may not vote on this poll
Directly write to a .log file
Write to a table first
Would use some other method
05-10-04, 03:47 #1Registered User
- Join Date
- Mar 2004
Unanswered: Custom Log files from SQLServer stored procedures
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.