Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shobhaaradhya
Starting Member
37 Posts |
 Posted - 2013-05-16 : 05:02:35
|
| Hi, One of the publication has few temp tables, which synchronises the data with subscriptions. I dont want this to happen. I mean I want to stop synchronizing data for few tables. Is there any way to do this?Thanks in advance,Shobha |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
shobhaaradhya
Starting Member
37 Posts |
Posted - 2013-05-16 : 05:22:10
|
Thanks for the reply, If I drop the article from the publication, these articles will be dropped from the subscriber also i mean does the snapshot contains this article.?Thanks,Shobhaquote:
Originally posted by visakh16
you need to modify the publication to drop the unwanted articlesseehttp://msdn.microsoft.com/en-us/library/ms152493.aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
|
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-16 : 05:24:51
|
quote:
Originally posted by shobhaaradhya
Thanks for the reply, If I drop the article from the publication, these articles will be dropped from the subscriber also i mean does the snapshot contains this article.?Thanks,Shobhaquote:
Originally posted by visakh16
you need to modify the publication to drop the unwanted articlesseehttp://msdn.microsoft.com/en-us/library/ms152493.aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
nope it wontRead the articleIt clearly explains the facts------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Stop synchronising few tables in replication.