Sean Lange:
> The RedGate tool is free so having access isn't really much of an issue.
I'm glad you posted code for an alternate method, because 3rd party tools...

Excellent.

Thank You.

Excellent.

Thank You.

Thanks for doing the Google search for an Oracle method. I will certainly have a look, as that would be very useful for me at work.

I tried changing:

SELECT...

Hi John,

For the present time, I modified the end of the procedure as follows:

[font="Courier New"]CLOSE dbnames

DEALLOCATE dbnames

--SELECT 'Search Results';

SELECT * FROM #TempBruteForce

WHERE Matches > 0 OR LEN(errortxt) > 0

ORDER...

Hello -

Very nice script!

I have two questions:

1.) What is the difference, if any, between "tblqry" and "sqltext" in the results?

2.) Is there a way to conditionally print the errors?

SELECT 'Errors...