Configuring Replication From Sql Server 2008.

--enabling replicatio for a database

use [AVehicles]

select * from cycles

exec sp_replicationdboption @dbname='AVehicles',

@optname='publish',

@value='true'

go

--adding a publication

use [AVehicles]

exec sp_addpublication @publication='final_pub',

@status='active',

@allow_pull='true',

@allow_push='true',

@independent_agent='true',

@immediate_sync='true',

@allow_sync_tran='true'

go

--adding article

use [AVehicles]

exec sp_addarticle @publication='final_pub',

@article='ar3',

@source_object='cycles',

@pre_creation_cmd='drop',

@force_invalidate_snapshot=1

go

--adding subscription

use [AVehicles]

exec sp_addsubscription @publication='final_pub',

@subscriber='BETASQL1',

@destination_db='Database_Pub',

@subscription_type='push'

go

--adding publication snapshot

use [AVehicles]

exec sp_addpublication_snapshot @publication='final_pub'

go

--starting snapshot

use [AVehicles]

exec sp_startpublication_snapshot @publication='final_pub'

go

--adding rows to articles

select @@SERVERNAME

sp_helpsubscription