Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


SQL Replication

Posted on 2009-04-15
Medium Priority
Last Modified: 2012-05-06
I have set up merge replication in SQL 2005.  In one of the tables that I am replicating there is a field that I do not want to replicate so I unchecked it when setting up the publication.  When I set up the subscription SQL deleted the unchecked field from the subscription DB.  I want the field there I just do not want the data replicated.  Has anyone had this problem or know of a way around this issue?
Question by:Codeonesysadmin

Expert Comment

by:Hemantgiri S. Goswami
ID: 24154593
Here an article on how to add/remove column in Merge Article http://msdn.microsoft.com/en-us/library/ms188063.aspx
LVL 10

Expert Comment

ID: 24181077
every time you have apply a snapshot you will have a problem as you objects will get rescripted and you column will disappear..   i would create another table that is not part of replication to hold this static subscriber data..

Accepted Solution

Codeonesysadmin earned 0 total points
ID: 24209878
We have changed the way we are replicating to work around this problem.  Thanks for your help.

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question