-- Running the snapshot for replication
use [Master]
exec xp_cmdshell '"C:\Program Files\Microsoft SQL
Server\80\Com\snapshot.exe"
-Publisher [REMOTESERVER]
-PublisherDB [CartonLabel]
-Distributor [REMOTESERVER]
-Publication [Tracker_062003]
-DistributorSecurityMode 0'
GO
It creates the agent just fine but I have to go to EM and manually
start the agent...
BOL states "The Replication Snapshot Agent utility configures and
begins the Snapshot Agent, which prepares snapshot files containing
schema and data of published tables and database objects, stores the
files in the snapshot folder, and records synchronization jobs in the
distribution database."
Thanks,
Curtis