SQL Server Management Studio 中的存储过程依赖项 [英] Stored procedure dependencies in SQL Server Management Studio
问题描述
我对 MS 世界了解不多,但现在碰巧我必须使用 SQL Server Management Studio 2008.
I don't know much about the MS world, but now it happens to be that I have to use SQL Server Management Studio 2008.
我的问题:我在表中有一个列,我需要查看可能对它起作用的所有存储过程.
My problem: I have a column in a table, and I need to see all the stored procedures that may be acting on it.
我尝试右键单击并转到查看依赖项",但这似乎没有返回应有的所有内容.
I tried right-clicking and going 'View Dependencies' but that doesn't seem to be returning everything that it should be.
像这样的问题:SQL Server Dependencies 有提供 3 种解决方案的答案
Questions like this one: SQL Server Dependencies have answers that offer 3 types of solutions
- 付费的第三方工具.
- 编写自己的脚本.
- 将所有内容导出到文本文件中并对其进行搜索.
WTF?我错过了一些明显的东西吗?事情真的是这样吗?我想这是一个非常常见的用例:你想改变表,你想确保你不会破坏任何东西.或者,假设您是第一次查看带有数据库的新项目,并且您想查看某些列如何填充存储过程.实际上没有快速简便的内置工作流程来执行此操作吗?
WTF? Am I missing something obvious? Is that actually how things work? I would imagine that this is a very common use case: you want to alter table and you want to make sure you won't break anything. Or if say you're looking at a new project with a DB for the first time and you want to see how certain columns get populated with stored procedures. Is there actually no quick and easy built-in workflow to do this?
推荐答案
如果您需要按名称查找数据库对象(例如表、列、触发器) - 请查看 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屋!