Search code examples
sqlsql-serverstored-proceduresssms

SQL Server Management Studio - find stored procedure by name over multiple databases

I have recently joined a software project that has approximately 20-40 databases.

Each database has at least 200 stored procedures, some of them have many more, so it is very slow for me to search for a particular procedure manually.

I know that there is a stored procedure which I need to look at to fix a bug, somewhere in the entire project, it is called XYZ_procedure

How do I search for this procedure over all of my databases in SQL Server Management Studio?

Solution

  • If you need to find database objects (e.g. tables, columns, triggers) by name - have a look at the FREE Red-Gate tool called SQL Search which does this - it searches your entire database for any kind of string(s).

    enter image description here

    enter image description here

    It's a great must-have tool for any DBA or database developer - did I already mention it's absolutely FREE to use for any kind of use??