Data scrubber regex does not terminate

[JamieOglethorpeEPS]

The finalCode = Regex.Replace... statement in DataScrubber.Scrub does not terminate.

scrubArray contains the following values:

• ([\s]*(declare[\s]+.+)+[\n\r]+([\s]*declare[\s]+.+)*[\s]*){0}
• {0}$1
• DECLARE statements are not covered since profiler does not capture them if there is no default value.

The attached file contains a cut down stored procedure illustrating the problem.

sqlcc_data_scrubber_regex_failure.txt

My workaround is to put a breakpoint on this statement and to use Set next statement to skip it.

[nickidw]

This has been fixed in my fork