Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010
    Posts
    10

    Talking Unanswered: Search for a Stored Procedure on an entire server

    Thought this might be helpful for anyone asking.

    sp_MSforeachdb 'Select ''?'' as Dbname, SPECIFIC_SCHEMA, ROUTINE_NAME
    From ?.INFORMATION_SCHEMA.ROUTINES
    where ROUTINE_NAME like ''%YourSPName%'''

    TraDog

  2. #2
    Join Date
    Dec 2010
    Posts
    10
    This is for SQL Server 2008

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •