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