How to search for text in MSSQL Stored Procedures

For those times you need to search for some text inside of all stored procedures in a database.

select * from INFORMATION_SCHEMA.ROUTINES where ROUTINE_DEFINITION  like '%find me something inside any stored procedure%'

admin

Chris Tran is a Software Business Manager from Brisbane, Australia. When he's not enjoying time with his family, he works with some very talented people at KoBold Group Pty Ltd.

More Posts

Follow Me:
TwitterFacebookLinkedInGoogle PlusFlickrYouTube

Comments