sp_check_for_sync_trigger (T-SQL)

Determines if a user-defined trigger or stored procedure is being called in the context of an immediate-updating trigger.

Syntax

sp_check_for_sync_trigger [@tabid =] 'tabid'
[,[@trigger_op =] 'trigger_op'] [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_op' [OUTPUT]

Is whether the output parameter returns the type of trigger it is being called from. trigger_op 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 and transactional replication.

Permissions

Members of the public role can execute sp_check_for_sync_trigger.