--creating the publication EXEC sp_addpublication @publication = 'pubs', @status = 'active' GO --creating the publication EXEC sp_addpublication_snapshot @publication = 'pubs' GO EXEC sp_grant_publication_access @publication = 'pubs', @login = 'BUILTIN\Administrators' GO -- Adding the transactional articles EXEC sp_addarticle @publication = 'pubs', @article = 'authors', @source_object = 'authors', @vertical_partition = 'true' GO -- Adding all columns EXEC sp_articlecolumn @publication = 'pubs', @article = 'authors', @operation = 'add' GO -- dropping the phone column EXEC sp_articlecolumn @publication = 'pubs', @article = 'authors', @column = 'phone', @operation = 'drop' GO -- Adding the article synchronization object EXEC sp_articleview @publication = 'pubs', @article = 'authors', @view_name = 'SYNC_pubs_authors' GO