Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Collapse the table of content
Expand the table of content


SQL Server 2000

Determines if a user-defined trigger or stored procedure is being called in the context of an updatable subscription. This stored procedure is executed at the Publisher on the publication database.


sp_check_for_sync_trigger [ @tabid = ] 'tabid'
    [ , [ @trigger_op = ] 'trigger_output_parameters' OUTPUT ]


[@tabid = ] 'tabid'

Is the object ID of the table being checked for immediate-updating triggers. tabid is int, with no default.

[@trigger_op = ] 'trigger_output_parameters' OUTPUT

Specifies if the output parameter is to return the type of trigger it is being called from. trigger_output_parameters is char(10), and can be one of these values.

Value Description
Ins INSERT trigger
Upd UPDATE trigger
Del DELETE trigger
NULL (default)  

Return Code Values

0 indicates that the stored procedure is not being called within the context of an immediate-updating trigger. 1 indicates that it is being called within the context of an immediate-updating trigger and is the type of trigger being returned in @trigger_op.


sp_check_for_sync_trigger is used in snapshot replication and transactional replication.


Members of the public role can execute sp_check_for_sync_trigger.

See Also

System Stored Procedures

© 2015 Microsoft