MSsync_states (Transact-SQL)

The MSsync_states table tracks which publication is still in concurrent snapshot mode. This table is stored in the distribution database.

Column name

Data type

Description

publisher_id

smallint

The ID of the publisher.

publisher_db

sysname

The Name of the publication database.

publication_id

int

The ID of the publication.