Sebfh/find_storedprocedure

Last active December 11, 2015 22:49

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Sebfh/4672352.js"></script>
Save Sebfh/4672352 to your computer and use it in GitHub Desktop.

Download ZIP

TSQL: Find stored procedures that contain a string of text

Raw

find_storedprocedure

	SELECT B.Name, *
	FROM syscomments A INNER JOIN sysobjects B
	ON A.id = B.id
	WHERE A.text like '%yourtext%'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment