MSsync_states

Transact-SQL Reference

Transact-SQL Reference

MSsync_states

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 ID of the publisher.
publisher_db sysname Name of the publication database.
publication_id int ID of the publication.