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.

See Also

Reference

Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views

Other Resources

Integration Services Tables
Backup and Restore Tables
Log Shipping Tables

Help and Information

Getting SQL Server 2005 Assistance