What does the value 30 indicate in the type column in the MSrepl_commands table?

86 Views Asked by At

Result Set of MSrepl_commands

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 operation
  • 2: Delete operation
  • 4: Update operation

So, 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.

0

There are 0 best solutions below