如何将所有插入调用标识到表中

I have a table that requires some schema changes which definitely will leave some impact behind especially during Insert. How can I find what are the clients/stored procedure/queries that doing insert into the table and also the related query?

我有一个表需要一些架构更改,这肯定会留下一些影响,特别是在插入期间。如何找到插入表中的客户端/存储过程/查询以及相关查询?

Is this possible to be achieved using SQL Profiler trace?

这可以使用SQL事件探查器跟踪来实现吗?

2 个解决方案

#1

This will give you the dependent Stored Procedures, Views, Triggers, Functions name on your table.

这将为您提供表格中依赖的存储过程,视图,触发器,函数名称。

You need to re-verify once you get the result, whether it is a insert statement or not.

一旦得到结果,无论是否为insert语句,都需要重新验证。

SELECT * 
FROM SYS.objects 
WHERE OBJECT_DEFINITION(object_id) LIKE '%INSERT%' 
AND OBJECT_DEFINITION(object_id) LIKE '%YOUR_TABLE_NME%'

You can change terms in LIKE Operator as per your requirement.

您可以根据您的要求更改LIKE运算符中的术语。

2 个解决方案

#1

更多相关文章

随机推荐