How to create a snapshot publication (Transact-SQL)

To create a publication (snapshot)

1. Execute sp_replicationdboption to enable publication of the current database.
2. Execute sp_addpublication with repl_freq set to snapshot to define the publication.
3. Execute sp_addpublication_snapshot to create a Snapshot Agent, set the publication agent_id, and place the schema and data into the replication working directory.
4. Execute sp_addarticle n times to define each article in the publication.

See Also