Thanks, I did have to change Where cause, link it to PERIOD <= @FiveYearAgo

Sorted Thanks guys, I overthought/overcomplicated this in my mind

It is still not working, I tried something similar, I think the issue is that @Period is an integer and @FiveYearAgo is not so if I do the where clause...

I am trying to link @Period to the PERIOD column on the table directly

Thanks, I will test this. I will modify this as I want to export this to a table so we can track monthly growth

Thanks, totally missed that

Agreed, I set them up in the same maintenance plan

Thanks Ed and Steve.

I should have looked further into the other maintenance plans. They are doing the job. Just a pity to have to do 2 maintenance plans to clear...

Hi Steve

Image 1,-- this maintenance plan is only for SQL Agent and Maintenance plan History, not for .bak and trn history

Image 2 -- On SQL Agent you will see I...

Should I be logging this as a Bug with Microsoft?

I also tried testing with a Windows authentication /AD user with admin rights on the server, this made no difference. it was owner of the Maintenance Plan and executed the...

Problem resolved, was a odd glitch in code that did not copy data from  from an order through to the GRN, you had to  reapply the order details, then the...

Different Companies need them so the question to we go with a single Reporting instance with complicated  User setups or Multiple Reporting instamces

Thanks guys. I have tried recreating it on other VMs, get the same issue every time SSMS version 17.4

All done thanks originally, also receiving test mails

Thanks all, we are looking at performance issues with better indexes etc