Maybe, but it shouldn't be for long unless you have a huge number of emails per day.  Of course, you would have had the same blocking (short and sweet)...

I did not include the progress table...you can add that in if needed:

    Use msdb;
     Go

    Set...

For a fixed width file - you should never have a comma in the data.  If you have a comma then it is most likely because you have a column...

The same thing - either return a NULL or convert the date into a string.  Depending on the downstream systems that will be using this - it generally is much...

You cannot define an export that will be a fixed width from SSRS - in order for a fixed width file to be generated you need to know the length...

You are returning a numeric value - and '' is not a numeric value so it will be converted to the corresponding numeric value of 0.  You can either return...

Sorry - I don't understand.

Are you saying you are going to supply the min/max values each time?  If so - then why batch the process and create a loop?  Just...

You are restoring the database to a clean installation of SQL Server...and no, there will not be any cobwebs or dust bunnies in the database.

There will be - however -...

Thank you for your help. I, mistakenly, understood it as meaning that it would create separate transactions in each sub package. I set it to see if it would...

I think there is a problem with this portion:

DELETE TOP (@top)
FROM msdb.dbo.sysmail_mailitems
WHERE (mailitem_id >= 1 AND mailitem_id <= 12000);
SET @rc = @@ROWCOUNT;

Once this code deletes the mailitem_id's...

You have 2 separate statements here - the second statement doesn't know anything about the first statement.

There are 2 ways to do this...use a CTE or a derived table:

            
May 14, 2020 at 8:08 pm
            
#3751718

            
            
                                                
        

I found that this was something I would forget every time I setup a new server - so I created a script to take care of both database mail and...

Is there a reason you changed the transaction support value to 'required'?  This is not the default value - and is forcing SSIS to create a distributed transaction and probably...

You could add an index on the column send_request_date - nothing preventing that index from being created (except space and time - of course).

The other option would be to batch...

Whether you free...