How to create a transactional publication (Transact-SQL)

To create a publication (transactional)

1. Execute sp_replicationdboption to enable publication of the current database.
2. Execute sp_addpublication with repl_freq set to continuous to define the publication.
3. Execute sp_addpublication_snapshot to create a Snapshot Agent, set the publication agent_id value, 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