Transact-SQL Reference

MSsnapshot_agents

The MSsnapshot_agents table contains one row for each Snapshot Agent associated with the local Distributor. This table is stored in the distribution database.

Column name Data type Description
id int ID of the Snapshot Agent.
name nvarchar(100) Name of the Snapshot Agent.
publisher_id smallint ID of the Publisher.
publisher_db sysname Name of the Publisher database.
publication sysname Name of the publication.
publication_type int Type of publication:

0 = Transactional
1 = Snapshot
2 = Merge

local_job bit Indicates whether there is a SQL Server Agent job on the local Distributor.
job_id binary(16) Job identification number.
profile_id int Configuration ID from the MSagent_profiles table.