PRB: No Error Occurs When Adding Trigger That Exists

ID: Q67806

The information in this article applies to:

Microsoft SQL Server versions 4.2x, 6.0, 6.5

SYMPTOMS

SQL Server allows a trigger to be overwritten without an error message.

CAUSE

By design, creating a new trigger of the same type (INSERT, DELETE, or UPDATE) on a table where a trigger is already defined is allowed in SQL Server.

Additional query words: trigger

Keywords : kbother SSrvGen
Version : winnt:4.2x,6.0,6.5
Platform : winnt
Issue type :