InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 01:40:41 GMT20http://www.sqlservercentral.com/Forums/Topic1417878-1549-1.aspxI could not get it to work through using the GUI. It would still prompt that a snapshot was needed. However, I was able to script it. I did have to make @pre_creation_cmd = 'none', but I also had to run the command sp_addsubscription with @sync_type = 'replication support only'. Here are the scripts with generic names.USE [PublicationDB]EXEC sp_addarticle @publication = N'Publication', @article = N'Table', @source_owner = N'dbo', @source_object = N'Table', @type = N'logbased', @description = N'', @creation_script = N'', [b]@pre_creation_cmd = N'none'[/b], @schema_option = 0x000000000803509F, @identityrangemanagementoption = N'manual', @destination_table = N'Table', @destination_owner = N'dbo', @status = 24, @vertical_partition = N'false', @ins_cmd = N'CALL [dbo].[sp_MSins_Table]', @del_cmd = N'CALL [dbo].[sp_MSdel_Table]', @upd_cmd = N'SCALL [dbo].[sp_MSupd_Table]'GOUSE [PublicationDB]EXEC sp_addsubscription @publication = N'Publication', @subscriber = N'Subscriber', @destination_db = N'SubscriberDB', @subscription_type = N'Push', [b]@sync_type = N'replication support only',[/b] @article = N'Table', @update_mode = N'read only', @subscriber_type = 0Mon, 18 Feb 2013 10:26:25 GMTsudonjnhttp://www.sqlservercentral.com/Forums/Topic1417878-1549-1.aspxThank you. I will try that.Thu, 14 Feb 2013 09:02:46 GMTsudonjnhttp://www.sqlservercentral.com/Forums/Topic1417878-1549-1.aspxEasy, peasy. When you create the article, specify "None" for @pre_creation_cmd (when using the sproc sp_addarticle). If you are using the GUI, when adding the article, go into "Article Properties" and scroll down to "Action if name is in use" and select "Keep existing object unchanged"Sun, 10 Feb 2013 20:04:34 GMThappycat59http://www.sqlservercentral.com/Forums/Topic1417878-1549-1.aspxYou are correct in that if I remove the article from the publication and add it back once renamed, a snapshot of only that table will be taken. I am trying to avoid taking a 350GB snapshot, and more-so, I am trying to have as little downtime as possible. It will take too long to create the snapshot and move that data to the replicated table.Fri, 08 Feb 2013 13:58:04 GMTsudonjnhttp://www.sqlservercentral.com/Forums/Topic1417878-1549-1.aspxyou can try adding newtable/ article to the existing publication by recreating the snapshot for that single article if you using transactional replicationFri, 08 Feb 2013 13:38:17 GMTpenu.v8http://www.sqlservercentral.com/Forums/Topic1417878-1549-1.aspxI have a 350 GB table that is replicated, and I need to rename. This will require replication to be stopped on this table. Is it possible to add a table to a publication without requiring a snapshot? You can do this when setting up a new publication, but I cannot figure out how to do it when adding an article to an existing publication. I do not want to create another publication for only this table.Fri, 08 Feb 2013 12:44:05 GMTsudonjn