Finding Text in Stored Procedures (SQL Server)

Well GST in New Zealand is changing which means losts of code auditing...

Heres a good time saver, search the text of your stored procedures

--Searching for "GST" in strored procedures
SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%GST%'

http://blog.sqlauthority.com/2007/11/10/sql-server-2005-2000-search-string-in-stored-procedure/

Soyuz5 was launched on January 15, 1969

Most remembered for its dramatic re-entry which left cosmonaut Boris Volynov hanging from his seat straps as he plummeted face first towards earth with atmosphere burning through his ship towards him.