Home
/
Knowledgebase
/
Windows
/
Clean RDM SQL ConnectionLog

Clean RDM SQL ConnectionLog

begin tran
declare @xMonths int;
set @xMonths = 6;
delete from [dbo].[ConnectionLog] where creationdate < dateadd(MONTH, - @xMonths, getdate())
commit tran