Alternatively, we can use this too.. it takes about an hour to delete a million records
set rowcount 50000
DELETE FROM EventTracking.dbo.Event
while @@rowcount>0
begin
set rowcount 50000
DELETE FROM EventTracking.dbo.Event
END
set rowcount 0
______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂