sql server - Finding T-SQL code with literal strings for localization project -

does have experience tools/techniques identify t-sql code literal strings (that may require language translation localization project)? love leverage another's experience may save me time developing own tool or - god forbid - doing manually.

just idea, this:

select     object_name(id),     [text]     syscomments id in (     select id     syscomments      [text] '%''%''%'      , objectproperty(id, 'isprocedure') = 1      group id ) 

that show every procedure constant string literal in it.

of course, if use many dynamic sql execution statements, you'll lot of false positives...

hope helps.