Microsoft KB Archive/67806

= PRB: No Error Occurs When Adding Trigger That Exists =

Article ID: 67806

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition
 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



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.

Additional query words: trigger

Keywords: kbother KB67806

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.