mssync-states-transact-sql.md

title	MSsync_states (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	replication
ms.topic	language-reference
f1_keywords	MSsync_states MSsync_states_TSQL
dev_langs	TSQL
helpviewer_keywords	MSsync_states system table
ms.assetid	b25e17e1-7718-432e-a442-c4946741d474
author	stevestein
ms.author	sstein

MSsync_states (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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

Mapping System Tables to System Views (Transact-SQL)
Integration Services Tables (Transact-SQL)
Backup and Restore Tables (Transact-SQL)
Log Shipping Tables (Transact-SQL)