BK Shailender
BK Shailender

Reputation: 1

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

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:

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.

Upvotes: 0

Views: 204

Answers (0)

Related Questions