Export (0) Print
Expand All

WITH CHANGE_TRACKING_CONTEXT (Transact-SQL)

Enables the context of a change to be specified, such as an originator ID, when data is changed. For example, when using change tracking, an application might want to differentiate between changes that were made by the application itself and changes that were made to the data outside the application.

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions

WITH CHANGE_TRACKING_CONTEXT ( context )

context

Is the contextual information that is supplied by the calling application and stored with the change tracking information for the change. context is varbinary(128).

The value can be a constant or a variable, but cannot be NULL.

The following example sets the change tracking context for a data change.

WITH CHANGE_TRACKING_CONTEXT ( context )
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft