Does anyone have samples scripts to adjust the Logon properties for the SQL Server Agent. Also could you please include the commands to start the agent and set its start-up property to "Automatic"


Also does anyone have experience with starting up the Snapshot Agent (replication). There is a Snapshot.exe file in the 80\COM folder under Microsoft SQL Server" these are its main switches:

-------------------------------------------------------------------------------------------------
snapshot -Publisher <..>
-PublisherDB <..>
-Publication <..>
[-ReplicationType <1|2> ]
[-Distributor <..> ]
[-DistributorSecurityMode <0|1>]
[-DistributorLogin <..> ]
[-DistributorPassword <..> ]
[-PublisherSecurityMode <0|1>]
[-PublisherLogin <..> ]
[-PublisherPassword <..> ]

Merge Replication Dynamic Snapshot Parameters:

[-DynamicFilterLogin <..> ]
[-DynamicFilterHostName <..> ]
[-DynamicSnapshotLocation <..> ]
[-StartQueueTimeout <..> ]
[-Continuous ]
[-Output <..>]
[-OutputVerboseLevel <0|1|2>]
[-LoginTimeout <..>]
[-QueryTimeout <..>]
[-DefinitionFile <..>]
------------------------------------------------------------------------------------------------
My problem is with the [-ReplicationType <1|2> ] switch. the value "2" is for merge replication, but when I use it, it keeps telling me that it couldn't find the Publication because it thinks it is a transactional (value = 1) replication.

Does anyone have a sample script for this?


Thanks!!