...
| Code Block |
|---|
USE Velocity DELETE TOP(1000000) FROM AlarmActive |
Execute Continue to execute the above query until you have deleted all active alarms, and the message box states zero rows affected.
The reason for deleting It is best to delete 1 million alarms at a time is to not exhaust the SQL Server from system memory.
...