如果我们删除插入权限触发器，它是否会成为问题 [英] If we delete insert permission triggers, can it be issue

问题描述

如果我们禁用与所有数据库关联的触发器以及与数据库中的表关联的触发器，它是否会产生任何问题。



这些触发器仅限制插入&删除操作。







是否有任何常规设置可禁用所有触发器？

如何查找数据库中的触发器列表？

Can it create any problem if we disable the triggers associated with all databases and those triggers which are associated with tables in the database.

These triggers just restrict insert & delete operations.



Is there any general setting to disable all the triggers?
How to find out the list of triggers in database?

推荐答案

我不知道您的数据库的完整设置，所以我无法建议关于禁用你的触发器。

但我可以帮你从数据库中检索所有触发器。试试这样，

I don't know full setup about your database, so i can't suggest about disable your triggers.
But i can help you to retrieve all triggers from your database.Try like this,

SELECT      Tables.Name TableName,
      Triggers.name TriggerName,
      Triggers.crdate TriggerCreatedDate,
      Comments.Text TriggerText
FROM      sysobjects Triggers
      Inner Join sysobjects Tables On Triggers.parent_obj = Tables.id
      Inner Join syscomments Comments On Triggers.id = Comments.id
WHERE      Triggers.xtype = 'TR'
      And Tables.xtype = 'U'
ORDER BY Tables.Name, Triggers.name

这不是我自己的代码，通过链接引用。

参考： < a href =http://geekswithblogs.net/KingSurfers_Brain/archive/2008/05/30/find-all-triggers-and-their-text-with-t-sql.aspx> http://geekswithblogs.net / KingSurfers_Brain /存档/ 2008/05/30 /发现，所有的触发器 - 和 - 他们的文本与t-sql.aspx [ ^ ]

这篇关于如果我们删除插入权限触发器，它是否会成为问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！