Hi Howard, As far as I know, you have to roll your own. What I did (probably not the only way) is add a Job to the SQL Server Agent to execute the following T-SQL command every hour: DELETE FROM <tablename> WHERE [date] < DATEADD(Hour, -12, GETDATE())
This will delete all entries older than 12 hours. Of course, the [date] field might differ per configuration. In my particular case I needed to save the date and time as two separate strings to support legacy code. My command is therefor slightly more complicated :) But it works well. I would love to know if there is a better way of doing this. Also, a configuration setting in log4net would be great! If I had the time I would try my hand at it myself. Being able to limit either the age of entries or the number of rows would be a godsend. Maybe (but that would be pushing it a bit) it would even be possible to 'relog' the soon-to-be-deleted rows to a FileAppender or SmtpAppender. Mmmm..coolness.. Anyway, hope this helps, Erik ------------------------------- Lead Developer Research and Development Group GPXS Wireless Ltd. Southampton, United Kingdom Phone: +44 (0) 23 8076 2519 Fax: +44 (0) 23 8076 2555 Email: [EMAIL PROTECTED] -----Original Message----- From: Howard Weisberg [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 13, 2005 7:36 PM To: [email protected] Subject: Buffer Flushing and Table Maintenance in the ADONetAppender Is there support for programmatically flushing the buffer? Is there support for deleting records in the SQL table that are older than a specified amount (to keep the table from growing without bounds) or do I need to roll my own? The information contained in this e-mail and any attached documents may be privileged, confidential and protected from disclosure. If you are not the intended recipient you may not read, copy, distribute or use this information. If you have received this communication in error, please notify the sender immediately by replying to this message and then delete it from your system. The information transmitted by this e-mail message is intended solely for the use of the person to whom or entity to which it is addressed. The message may contain information that is privileged and confidential. Disclosure, dissemination, distribution, review, retransmission to, other use of or taking any action in reliance upon this information by anyone other than the intended recipient is prohibited. If you are not the intended recipient, please do not disseminate, distribute or copy this communication, by e-mail or otherwise. Instead, please notify us immediately by return e-mail (including the original message with your reply) and then delete and discard all copies of the message. Although we have taken precautions to minimize the risk of transmitting viruses we nevertheless advise you to carry out your own virus checks on any attachment to this message. We accept no liability for any loss or damage caused by viruses.
