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