arthur.teter (8/2/2013)
I never noticed before today that the corresponding definition fields in the information_schema views are limited to the first 4000 characters of the script.
Same with syscomments, which you should avoid using because it's only there for backward compatibility and could be deprecated in a future release. Not only that, sys.sql_modules has the whole definition on one row, so you won't miss out if your search string straddles the 4000-character boundary.
John