PRB: No Error Occurs When Adding Trigger That Exists

ID Number: Q67806

1.10 1.11 4.20

OS/2

Summary:

SYMPTOM

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 reference words: trigger