Short Coding Snippet

1.Download Wget Tool using below url : https://eternallybored.org/misc/wget/ and download latest available tool 2.copy wget.exe to C:\Windows\System32 3.Open Task Schedular in Windows 4.Create Action  and under Action enter below things Program/Script : Wget Argument : --append-output=C:\Wget\page.txt https://www.abcd.com/page.aspx

Option 1 : SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%Foo%' AND ROUTINE_TYPE = 'PROCEDURE' Option 2 : SELECT OBJECT_NAME(id) FROM SYSCOMMENTS WHERE [text] LIKE '%Foo%' AND OBJECTPROPERTY(id, 'IsProcedure' ) = 1 GROUP BY OBJECT_NAME(id) Option 3 : SELECT OBJECT_NAME(object_id) FROM sys.sql_modules WHERE OBJECTPROPERTY(object_id, 'IsProcedure' ) = 1 AND definition LIKE '%Foo%'