SQL Server Management Studio - 按名称在多个数据库中查找存储过程 [英] SQL Server Management Studio - find stored procedure by name over multiple databases

问题描述

我最近加入了一个拥有大约 20-40 个数据库的软件项目.

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

每个数据库至少有 200 个存储过程，其中一些存储过程更多，因此我手动搜索特定过程非常慢.

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.

我知道我需要查看一个存储过程来修复整个项目中某处的一个错误，它被称为XYZ_procedure

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

如何在 SQL Server Management Studio 中的所有数据库中搜索此过程?

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

推荐答案

如果您需要按名称查找数据库对象(例如表、列、触发器) - 请查看 FREE 红色-名为 SQL Search 的 Gate 工具执行此操作 - 它搜索任何类型字符串的整个数据库.

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).

对于任何 DBA 或数据库开发人员来说，它都是一个很棒的必备工具 - 我是否已经提到它绝对免费用于任何类型的用途??

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??

这篇关于SQL Server Management Studio - 按名称在多个数据库中查找存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！