Thursday, April 5, 2012

Searching Procedures for Key Terms

   SELECT name
        , object_definition(object_id) 
     FROM sys.procedures 
    WHERE object_definition(object_id) LIKE '%SomeSearchTerm%'


No comments:

Post a Comment