This script will quickly generate DML to search all the tables in the current database for a given string. It could be modified to execute the generated code if desired. If you are running this in a <2005 environment, convert the VARCHAR(MAX)s to VARCHAR(8000) and be careful of overflowing the variable if you have very wide tables. To use this script, simply set the value of @SearchItem to whatever string it is you are searching for on line 2 then run in the database you wish to search.
Handling The Text Data Type
Robert is back this week with a look at the text data type. Not the easiest thing to work with, but sometimes a varchar just doesn't give you the range you need.
2003-05-07
26,334 reads