Reputation: 1
I want to infer that whether its a insert/update/delete command . We need to check at day end the amount of data replicated per article by the transactional replication. In the internet I am getting belwo result:
The type
column in the MSrepl_commands
table indicates the type of operation that the command represents. Here's what the different values mean:
1
: Insert operation2
: Delete operation4
: Update operationSo, if a row in the MSrepl_commands
table has a type
value of 1
, that means the command is an insert operation. Similarly, 2
represents a delete operation, and 4
represents an update operation.
Upvotes: 0
Views: 204