SQL Search From Red Gate To search across Sql Server using plain string

SQL Search – quickly find SQL in SSMS

•     Find fragments of SQL text within stored procedures, functions, views and more
•     Quickly navigate to objects wherever they happen to be on a server
•     Find all references to an objec
• SQL Search is an add-in for SQL Server Management Studio that lets you quickly search for SQL across your databases.

http://www.red-gate.com/products/sql-development/sql-search/

Date Time Using CMD

%date:~-4,4%%date:~-7,2%%date:~-10,2%%time:~-11,2%%time:~-8,2%%time:~-5,2%

– Returns date time in YYYYMMDDHHMMSS format.