Just a few "litmus strip" questions to start with:

1. What is the exact call code that you're using to call Ola's script? (Please post it for the database in question...

All-righty then...

You say that you want all of the special characters to be replaced by spaces except for "&" to be replaced by "+" and "=" to be replaced by...

Is there a better/more efficient way to do what the below does? It is  replacing several characters that are known to be problematic for this table/column(s) with a space.

BONUS...

Registration isn't open, but you can sign up: https://passdatacommunitysummit.com/twentyfour/

That way you can get the lowest price when it opens.

I do think they're pretty good about moving registration to...

Just a suggestion... Keep It Super Simple and flexible at the same time.

Here's the test table (not part of the solution):

   DROP TABLE IF EXISTS #TestTable;
GO
 SELECT *
  ...

Hopefully, you're REALLY selective about which stats get updated.

Actually, it could be simplified even more.  Since it always tries to run on Thursdays, we don't need to figure that out.  We just need to figure out if the...

Totally agreed.

12am full to 2am diff is 26 hours for the first one, so no, not 24 hours.

In terms of your last question, changing logins makes changes in master. Changing...

As a bit o a sidebar, I've found that the cutover point between DELETES and COPY to a new table is actually about (depending on the table, of course) only...

Hadn't thought about that.  Thanks, Scott.

Looks like they fixed it!

Heh... pretty typical for things like this.  The OP asks a question and then never participates in their own thread.  While some great code has been posted, there...

these are read-only dbs.  there's...

Heh... pretty typical for things like this.  The OP asks a question and then never participates in their own thread.  While some great code has been posted, there are still...