24-03-2015, 04:59 PM
(24-03-2015, 04:44 PM)DevOma Wrote: The fast way is to delete all :-)
TRUNCATE TABLE vCCErrorLog
else every row will be deleted one by one and that could take a really long time :-) 30 minutes to 1 hour (or perhaps more) I guess...
DELETE FROM vCCErrorLog WHERE _InsertDate < DATEADD(day, (-30), getutcdate())
That solved the issue.
Thank you!