use master GO sp_replicationdboption 'pubs','publish','true' GO use pubs go sp_addpublication 'authortitles', @status='active' go sp_addpublication_snapshot 'authortitles' go sp_addarticle 'authortitles','authors','authors' go sp_addarticle @publication='authortitles', @article='authortitles', @source_table='titleauthor', @destination_table='authortitles', @sync_object='AuthorTitles_Sync_Object', @schema_option=0x00, @creation_script='c:\test.sql', @ins_cmd='CALL sp_MSins_authortitles', @del_cmd='CALL sp_MSdel_authortitles', @upd_cmd='MCALL sp_MSupd_authortitles' GO