No backdoor....

One way or another, they're still at it

Thanks. I was asking because I was wondering whether your suggested countermeasures would even be effective.

I had to turn off notifications to pretty much all forums as a result of...

they are...

Out of interest, are the spammers (and their bots) using the standard GUI to create these posts, or is there a back door that they've hacked into?

today was a busy day for spammers.

I've reported likely over 400 posts today.  92 of them from a single user, and a few others with 55  posts each.

really would...

OK, sequential is good. I don't have much more to suggest.

Perhaps you could try shuffling the processing order. This would help determine whether the problem is with that specific component,...

Are you doing the Excel updates in series or in parallel?

That's a good way. You could always build a wrapper proc around it to cater to your needs and defaults, making it as straightforward as possible.

Have you looked on the startup parameters for the SQL Server service in SQL Server Configuration Manager? There is an option to configure the location of the error log there....

Thanks that was a good exercise but that's for two points . I was hoping some type of calculation that draws a radius and returns all the points that...

OK, then you have your solution, assuming you don't care about the ordering of...

The solution proposed above works only if 'Customer called' and 'Customer left message' happened at exactly the same time. As they appear to be two separate rows of data, I'm...

Assuming your SSIS packages are deployed to SSISDB, try looking inside

SSISDB.catalog.operations

Assuming you want your output columns to be dynamic, based on the input data, this really is best achieved in a reporting tool.

What would your desired output look like if...