BUG: Immediate Updating Subscriber Builds Trigger Incorrectly

ID: Q199223

The information in this article applies to:
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.

Additional query words: 


Keywords          : SSrvRep kbSQLServ700bug 
Version           : winnt:7.0
Platform          : winnt 
Issue type        : kbbug

Last Reviewed: July 27, 1999