Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Converting database from ASG 2012 -> 2015
#7
(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!
Reply


Messages In This Thread
RE: Converting database from ASG 2012 -> 2015 - by jossemann - 24-03-2015, 04:59 PM



Users browsing this thread: 1 Guest(s)