Re: Purge old ROWS

From: Rick Rohne (rohnerno_spam_at_nordyne.com)
Date: 06/01/04 

Date: Tue, 01 Jun 2004 13:53:46 -0700

Thanks for the information, It worked perfectly. FYI: I am using this
for ODBC logging on IIS web servers. They send the logs to a SQL server
and I purge them as they get old.

Works very well thanks,

DELETE FROM inetlog
WHERE LogTime < dateadd(month, -2, getdate())

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!