PRB: No Error Occurs When Adding Trigger That Exists (67806)
The information in this article applies to:
- Microsoft SQL Server 4.2x
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
This article was previously published under Q67806 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.
| Modification Type: | Minor | Last Reviewed: | 2/14/2005 |
|---|
| Keywords: | kbother KB67806 |
|---|
|