ok, thanks

Here is the script for the change of statement if in simple mode.  The reason I mention this is because I have changed our database to simple mode.  When I...

Thank You to everyone for all the help.

understood.  I reviewed a script that had a command at the end and the command had to change according to the recovery model.  Can't find it and I don't remember...

Thank you, that works perfectly and is easy to understand what the script is doing
GOOD JOB!!!
Will anything have to change when I move the recovery model to Simple? ...

1. How can I make this loop until the IF statement is false? 
2. I don't care what records are deleted and I just want to keep the row...

email worked flawlessly.  THANK YOU>>>>
I need to create the delete loop of 4K records at a time until there are 200K records remaining by calling a stored procedure

This works to send email but how can I insert the @tableRows in the body of the email?

USE Alarms

DECLARE @tableRows int
SELECT @tableRows=COUNT(1) FROM [GW-PLC].[AllEvent]

good idea, thanks.

ok
I will work on that
I have the database copied into a test system to run the sql statements against.

I see the 2 parts.  Loop delete / email.  What is the best way to incorporate this?  How do I incorporate the loop delete statement into the last sql statement?

Thank you for the information.  It is very helpful.
The link explains how to handle the loop process.  Why does it say "but for it to have meaning, batch size...

Good question.
Yes, This column is good with event date/time stamp [EventTimeStamp] [datetime2](7) NULL,
Definitely want to delete the oldest records first.
Couldn't figure out how to edit the title.  The...