.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Updatable Subscriptions: Rows do not match between Publisher and Subscriber. Run the Distribution Ag

Posted By:      Posted Date: October 07, 2010    Points: 0   Category :Sql Server


I have a transactional replication with updateable subscription when i try to update  arow on the subscriber the error i got is :

Updatable Subscriptions: Rows do not match between Publisher and Subscriber. Run the Distribution Agent to refresh rows at the Subscriber.


View Complete Post

More Related Resource Links

How to prevent Propagation from subscriber to Publisher in some occations

We are using merge application. We need sometimes delete some tables at subscriber and that delete command or any other command  should not propagate to Publisher and other subscribers. And sometimes it should be refilled from Publisher. Is it possibe? Second question : My publisher crashed two times. I could attach the database after restoring the OS. But at subscriber I am unable to modify some table and it gives the error invalid object name 'dbo.msmerge.......'. Replication is working fine. What is the reason for this error and how I can get rid of it?

SQL Server 2005 as Distributor, Subscriber - SQL Server 2008 as Publisher

Hi,           I am creating a Distributor on SQL Server 2005 the server name is Server1 and Server1 is the Subscriber as well, we are using Push Subscription           Publisher is on SQL Server 2008, Server2. When i try to create a Publications, it throws the following error.          Server "Server1" is an Older Version of SQL Server and cannot be the Distributor for Server  'Server2'  Server1 - Distributor, Subscriber  Server2 - Publisher Is there any way to overcome this issue..? Regards, Fazlu.

Transactional publication with updatable subscriptions in SQL Server 2005, SvPk 2

Subscription to "Transactional Publication with Updateable Subscriptions" works only one way.  Changes take effect on subscriber, but the subcriber is unable to update data on publisher.   I have Sanpshot Agent process running under SQL Server Agent service account with login 'sa.'  All agents are running at the Distributor (Publishing Server.)   The subscriber is unable to connect to the Distributor using the SQL Server login.    Following is the error message I get:   Creating Subscription(s)... - Creating subscription for 'SQL3' (Warning) Messages Unable to set the Publisher login for the updatable subscription. You may have to set this up directly on the Subscriber machine using sp_link_publication. (New Subscription Wizard)------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------MSDTC on server 'SQL3' is unavailable.Changed database context to 'DB_SQL1_to_SQL3_on_3'. (Microsoft SQL Server, Error: 8501)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=8501&LinkId=20476   Please suggest procedure to end this dilemma.  The link has no info available.

Latency Alerts from SQL Server 2008 (Distributor and Publisher) and SQL Server 2005 (Subscriber)



     We are using Transactional Replication with Distribution and Publisher in One Server (Ex: ServerA) which is SQL Server 2008 and Subscriber Server is (ServerB) which is SQL Server 2005. Can anyone let me know how to set the Latency Alerts. If Possible please provide the link which will explains step by step.

Thanks in Advance



SSAS Excel Drill Thru : Number of Rows Returned don't match up


Hi, I have created an excel report which connects to my cube and have created drill thru action. When I double click on data cell in excel, what I would expect is to give details for that cell. For example, I have a cell in excel that represents 1000 Sales made. When I double click on it, it should only show me thousand rows, however for some reason it gives me more than 1000 rows. So basically the cell counts don't tie with drill thru row counts.....

Any idea on how I can rectify this?

Estimated number of rows does not always match actual number of rows


I am looking at some code that I am writing and keeping an eye out for performance, what i do notice is that on the for left of the query plan by the select/delete, if I place the mouse cursor on the arrow the actual number of rows hardly ever matches the actual number of rows.

Is there anything that I can do to resolve this, I do notice that one needs to update statistics or reorg/rebuild indexes but still the inconsistency exists. Is there a better explanation for this ?


Merge Replication Atomicity - at what point does ALL subscriber data become visible at the publisher



I have a Merge Replication installation going on with about 35 connected devices. When one of the subscribers synchronizes, do the inserted rows appear sporadically on the publication database at different times? Or do they appear all at once?

Can all of these be isolated inside a transaction - this would seem like it should be the default behaviour, in case of a sync being cancelled or failing due to loss of connectivity etc. 

The reason for this question is that another part of the system seems to have queried the publication database during and after a subscriber synchronization with differing results. 

If this is normal, what would be the best solution to ensure data integrity? 

Thank you in advance. 


How to determine which table is published from subscriber without involving distribution db


We have transactional replication in our environment and what I would like to find out if list of replicated tables could be retrieved from the subscribers only without involving distribution database.

SELECT Source_Owner, Source_Object FROM RemoveServerName.Distribution.dbo.MSArticles

Instead of doing remote query as above my interest is to determine from the subscriber if certain table is being published.

Pub/Subscriber Record Mis-match WITH strange behavior


We have hundreds of Publication we replicate via transact replication.


One such set of publications (all of them for the DB I will discuss) were found to have more records on the publisher than on the subscriber.


It was not a matter of a DML operation removing the records on the subscribers.


Here is a hit list of what happened and what we did …



Transactional replication with updatable subscriptions makes log file huge...




 We are doing Transactional replication with updatable subscriptions. We need to create the replicated db on same server. The recovery model is simple. The original DB has been restored from sql2000. But when I do the replication, the publishercreation fails saying that the database recovery mode is set to full,the log file is full and try freeing up some space in thelog. I can also see the log file growing in size but if I check the recovery mode, it is still 'Simple'.  The log file becomes huge like 10GB and also I cannot truncate it as it has unreplicated txn. I have not tired taking Txn backups, in first place I do not need because recovery mode is simple and that would not truncate it as log file has unreplicated txn's in it.

I wonder how the db recovery mode is being changed to full. I have not seen this happening before when doing replication.

I tired repolicating small subset of tables, but I see two copies of th table in the replicated db, one is regauld table has all the info and the other on is conflict_table name, it does not have any data in it.  do not know why it is happening?


Help greatly appreciated!!



how many subscriber we can add to a publisher

i want to know how many subscriber we can add to a publisher
Thanks $ Regards Pawan Singh

Merge Replication - Publisher Identity Range Assignment with Disconnected Subscriber


Hello everyone,

I have a merge replication topology setup as follows...  Publisher - SQL 2008 SP1, Distributor - SQL 2008 R2 (RTM), Subscriber - SQL 2008 SP1.

I recently had my subscriber disconnected for a couple days.  During this time, I was getting the following error on my publisher:

The insert failed. It conflicted with an identity range check constraint in database 'production', replicated table 'dbo.CustomerOrder', column 'CustomerOrderId'. If the identity column is automatically managed by replication, update the range as follows: for the Publisher, execute sp_adjustpublisheridentityrange; for the Subscriber, run the Distribution Agent or the Merge Agent.

I understand why I would normally get this error, but if the publisher and distributor are both online, why didn't the publisher attain a new range from the distributor after it hit its threshold?  Is this expected behavior whenever a subscriber is disconnected?

Thanks in advance.


Adding Dynamic Rows in ASP.NET GridView Control with TextBoxes and with Delete functionality

In my previous examples, I have demonstrated on how to add dynamic rows in GridView control with TextBoxes and how to save the values into the database. Now, seems that most of the developers are asking if how to add a delete functionality with it. So in this example, I'm going to show on how to delete a certain row in the dynamic GridView with TextBoxes.

jQuery: Highlight Gridview Rows with Checkbox

Im learning and experimenting with jQuery and ASP.NET. Below is a simple solution I created to highlight rows in a gridview by clicking on a checkbox next to the row.

Gridview setup:

Highlighting Rows with TextBox OnFocus

In another article I explained that how you can make the rows of the GridView control clickable and highlight them when they are clicked. In this article I will explain that how you can highlight the GridView rows when you focus on the TextBox which is contained inside the GridView control.

jQuery: Highlight Gridview Rows with Checkbox

Im learning and experimenting with jQuery and ASP.NET. Below is a simple solution I created to highlight rows in a gridview by clicking on a checkbox next to the row.

jQuery: Styling DropDownList Alternating Items (Rows)

In the following example, I will show how you can style any asp:dropdownlist very easily.

The example demonstrates how you can change alternating row items background color, using the fadeTo() to add a nice touch in the dropdownlist. You can change alt rows with a couple lines.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend