Export (0) Print
Expand All
Expand Minimize

MSsnapshot_agents

SQL Server 2000

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft