When you say contain the word "FACTS", where does it contain it? In the name of the object (trigger)? The name of the table it is attached to? The word...

Is that output table a single column...? I'd suggest it would be better to have each item as a column. Why do you want to convert it into Delimited Tab...

I assume you mean that you want the recipient to be dynamic based on something? This is achievable. with SSRS.

Don't quote me on it, but I believe it's...

Going to be honest, but the sea of images and a mad morning at work, have made me completely loss track what your aim is now. We've identified that the...

Indeed. You need to know what is right for you. For example, like I said, mine is set to 7 days. The reason being that we run a LOT of...

As Anthony said, I treat SSISDB just like any other user database. it is backed up on the same schedules, by the same scripts etc.

Hmm, I'll create a container on the desktop and have a go myself quickly. I'll let you know how it goes.

edit: Sorry, not in a position to give...

It's your log file that is large. That screen shot says that it has a initial size of 8.7GB~. Why is it so large when you have a Simple Recovery...

I'm pretty surprised that your SSISDB is 10Gb in size then. If we have an look at my SSISDB database, it is 4.5GB~ in size, of which 900MB~ is available...

What have you set the "Operations log Retention Period" to? Also what about the "Maximum Number of Version per Project" and "Periodically Remove Old Versions" Settings?