csharpforevermore/ElmahTrim.sql

Created February 9, 2014 14:29

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/csharpforevermore/8899829.js"></script>
Save csharpforevermore/8899829 to your computer and use it in GitHub Desktop.

Download ZIP

Trim ELMAH database log table. Removes any entries older than 90 days (d = days, 90 = count). Original by Scott Mitchell (founder of 4GuysFromRolla.com)

Raw

ElmahTrim.sql

	DELETE FROM [ELMAH_Error]
	WHERE TimeUtc < DATEADD(d, -90, getdate())

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment