Create SSC_FindExactStringInDatabase

Here's a stored procedure to search all columns of all tables in the current database for a string.

It limits the target string to ANSI characters of length 128 or shorter, but you can adapt it as necessary.

You'd invoke the stored procedure something like this:

execute SSC_FindExactStringInDatabase 'XYZ132';

See the argument list for options.