Sql server不允许在表中复制或插入记录 [英] Sql server not allowing to copy or insert records in a Table

问题描述

我在sql server数据库中遇到表问题。它不允许复制记录或从软件中插入新记录。



以前当我禁用触发器时，它允许这样做，但现在也没有影响。似乎问题日益增加。



当尝试将记录复制到新表或尝试删除表时，它会给出以下错误。

I am facing issue with tables in sql server databases. its not allowing to copy records or insert new record from software.

Previously when I disable trigger, it was then allowing to do so, but now that also not have any effect. Its seems problems are increasing day by day.

When trying to copy records to new table or trying to drop a table, it gives below error.

Msg 3609, Level 16, State 2, Line 1 The transaction ended in the trigger. The batch has been aborted.

启用触发器会产生问题，如果禁用，则工作正常。



请帮助。

Enabling trigger creates issues, if its made disable, then works fine.

PLEASE HELP.

推荐答案

因为错误说有与此表关联的触发器。如果要删除任何表，则需要先删除所有相关约束。

As error says there are triggers associated with this table. If you want to drop any table you need to drop all the related constraints first.

这篇关于Sql server不允许在表中复制或插入记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！