sp_addpublication 'pubs',@status='active' go sp_addpublication_snapshot 'pubs' go --creating a custom sync object CREATE VIEW Custom_Sync_Object AS SELECT au_id, au_lname, au_fname, phone, address, CONVERT(char(20), ' ') AS address1, city, state, zip, contract FROM dbo.authors GO sp_addarticle @publication='pubs', @article='test', @source_object='authors', @sync_object='Custom_Sync_object', @schema_option=0x00, @creation_script='c:\test.sql'