Post reply

Search Stored Procedures

  • December 9, 2004 at 1:53 pm

    #60026

    Hi there,

    I need to make a change to a WHERE clause in a stored procedure.  Thing is, the same WHERE clause could possibly be in a hundred or more stored procedures.

    Is there a system table that will tell me which stored procedures contain the WHERE clause I am looking for?

    Thanks in advance

  • December 9, 2004 at 2:13 pm

    #533252

    Take a look at syscomments in the master database.

    Steve

  • December 9, 2004 at 2:20 pm

    #533254

    actually it's the syscomments table in the database in which the sps are kept.

  • December 9, 2004 at 2:42 pm

    #533255

    Thanks to both of you!  I was able to find what I was looking for.

  • December 10, 2004 at 3:49 pm

    #533410

    There was a great script here just recently, sp_grep, which allowed you to search your stored procedures.

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply