清理DNN日志的SQL语句

delete from [dbo].[EventLog]
delete from [dbo].[Exceptions]
delete from [dbo].[ExceptionEvents]
delete from [dbo].[EventQueue]
 
 
如果数据比较的多, 使用下面这个
set rowcount 100000
delete from [dbo].[EventLog]
set rowcount 0
 
 
WHILE 1 = 1
BEGIN
DELETE TOP(5000) FROM dbo.EventLog;
IF @@rowcount < 5000
BREAK;
END