Knowledge Base

BUG: Immediate Updating Subscriber Builds Trigger Incorrectly

Article ID: 199223

Article Last Modified on 10/16/2002

Microsoft SQL Server 7.0 Standard Edition

This article was previously published under Q199223

BUG #: 52381 (SQLBUG_70)

SYMPTOMS

The Immediate Updating Subscriber publication builds the trigger on the subscribing table incorrectly. Instead of referring to the INSERTED table, the trigger refers to the source table.

WORKAROUND

Change the trigger to refer to the INSERTED table.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

MORE INFORMATION

For example, suppose that you are filtering the "authors" table in the "pubs" database to publish only the rows for the states that have a matching value in the "states" table.

The WHERE clause built in the trigger is:

Where authors.st exists(select * from states where states.st = authors.st)

Instead, modify the trigger to be:

Where authors.st exists(select * from states where states.st = INSERTED.st)

This problem may also occur if the destination table has a different name.

Keywords: kbbug kbpending KB199223