Microsoft KB Archive/288395

= BUG: SQL Server Books Online Does Not Display DELETE as an Option in the CREATE TRIGGER Topic =

Article ID: 288395

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q288395



BUG #: 351664 (SHILOH)

BUG #: 235437 (SHILOH)



SYMPTOMS
The Syntax heading of the CREATE TRIGGER topic in SQL Server Books Online does not state that DELETE triggers can be created although it is possible to create DELETTE triggers.

The syntax shown in SQL Server Books Online is: CREATE TRIGGER trigger_name ON { table | view } [ WITH ENCRYPTION ] {    { { FOR | AFTER | INSTEAD OF } { [ INSERT ] [, ] [ UPDATE ] } [ WITH APPEND ] [ NOT FOR REPLICATION ] AS        [ { IF UPDATE ( column ) [ { AND | OR } UPDATE ( column ) ] [ ...n ] | IF ( COLUMNS_UPDATED { bitwise_operator } updated_bitmask ) { comparison_operator } column_bitmask [ ...n ] } ]        sql_statement [ ...n ] } } Note that [DELETE][,] is missing in line 5.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 2000 Books Online.



MORE INFORMATION
The DELETE keyword is included under the Arguments heading of the CREATE TRIGGER topic.

Keywords: kbbug kbpending KB288395

-

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

© Microsoft Corporation. All rights reserved.