sp_check_for_sync_trigger
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.
Syntax
sp_check_for_sync_trigger [ @tabid = ] 'tabid'
[ , [ @trigger_op = ] 'trigger_output_parameters' OUTPUT ]
Arguments
[@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.
Remarks
sp_check_for_sync_trigger is used in snapshot replication and transactional replication.
Permissions
Members of the public role can execute sp_check_for_sync_trigger.