Search

Wednesday, November 17, 2010

SQL 2005 - Word Search

Search for a word that a stored procedure might be using. The code bellow shows all the stored procedure that contain the word "DeptID"

SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '% DeptID %'

No comments:

Post a Comment