Problem : Error " You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels " generated when altering published table columns in a transactional replication. Cause : Unable to alter columns on Published...

Snapshot files for a transactional publication are immediately removed after being generated by the snapshot agent I had recently worked on this issue and decided to post my findings as this may help others that are experiencing the same issue. ...

Manual Cleanup What can one do when the distribution cleanup job is unable to cleanup the transactions in the distribution database? If this should occur, one should analyze why this is happening as the cleanup job is essential to the replication...

PART IV: "How To" get down to whatever is bringing SQL to its knees... At this point, one should know already whether or not they have memory pressure / cpu bottleneck / disk issues (previous blog posts). With that information, we now filter down...

After writing about "How to analyse SQL Server Performance", I decided to write a post about SQL Nexus, which, if I am not mistaken, I have mentioned before in previous posts. SQL NEXUS : Download tool from: http://www.codeplex.com/sqlnexus ...

Problem : I wanted to change the schema of a table which was published in my replication topology. I removed the table from two publication in which it was being published and tried changing the column name. This failed with the following error: ...

A lot of users have wondered about the performance latency transactional replication suffers over WAN. After analyzing / discussing this within the teams, here are the main points one should take into consideration when deciding / testing this type...

Problem : I have a random issue with a few of my Compact Edition subscribers. The issue that occurs is that the synchronization fails to complete with the following error message: An error occurred while reading the .bcp data file for the 'MSmerge_rowtrack...

Problem : I create a SQL Server 2005 replication topology on my Windows 2003 server. Everything synchronizes fine. I then go and add a default constraint to an article. Subscriber is synchronized and the default constraint is propagated to the...

Problem : I have a transactional replication topology that consists of SQL 2005 and SQL 2000. I managed to generate the snapshot but when I try to apply it on the subscribers, I get the following error: Error number 20598: " The row was not found...

Problem : Topology : - Merge replication with statically-filtered publications. - 2 publishers, CLSILVA1 and CLSILVA2, which are publishing a different set of tables - Many subscribers; most of them are subscribing to both publishers into...

one possible cause... There are many factors that can influence the performance on a transactional replication topology. I would like to address one that is not so commonly known. Problem : I had worked on an issue in which we were experiencing...

Problem : SQL Server 2008 Merge replication with automatic identity range handling. Suddenly, every insert on a specific table (TABLE1) stopped working with message: The insert failed. It conflicted with an identity range check constraint...

I have come across this interesting issue in which we have the following scenario: Merge Replication All servers are running SQL 2008 When merge replication is processing certain published articles, we see that the merge agent is blocked, and...

http://blogs.msdn.com/psssql/archive/2010/01/08/important-sql-server-and-windows-end-of-support-dates-you-should-know-about.aspx taken from the blog above, this information is important for all to know: Important SQL Server and Windows “End of Support...

Here are some interesting questions, and their respective answers, which may clarify a few things in regards to replication: Best practices replication performance: The first place to look is the SQL Server 2008 Books Online, especially the...

A little explanation before explaining how to resolve this issue: The retention period for subscriptions specified for each publication controls how often the Publisher and Subscribers should synchronize. If subscriptions do not synchronize with the...

Problem Description : SQL Server 2008 SP1 Transactional Replication CDC enabled I have an issue that occurs while trying to disable CDC on one of my databases. When I execute the system stored procedure sys.sp_cdc_disable_db, the procedure will hang waiting...

one possible cause... I had worked on an issue which I found quite interesting so decided to post it in order to share with everyone. Problem : I change a row on the subscriber. Once that is done, I then see that the change is propagated to the...

Problem : When I try to configure a SQL Server 2008 to be a remote distributor of my SQL Server 2005 / 2000 instance, I get the following error generated when using the GUI wizard: Could not find stored procedure 'sp_replcheck_qv' This prevents...

Problem : When I upgrade my SQL Server 2000 SP4 to SQL 2008 SP1, I am unable to verify my replication using Replication Monitor as it only shows a red X. I remove and re-add the publisher but still obtain the same result. Cause / Workaround ...

Problem : I have set up a Transactional Replication with Updatable Subscribers on my SQL 2005 server and created user triggers on the Publisher database. These triggers have been configured with “not for replication”. I update my subscriber...

Invalid object name "dbo.sysmergearticles" : I have seen issues on Forums where people state that they get the error "invalid object name dbo.sysmergearticles when they try to replicate their subscriber with their publisher. I had recently...

I have seen this issue many times and decided to share my experience and how this issue may be resolved: Problem : I have installed a SQL Server 2005 and IIS on the same machine and all is working fine via HTTP. SQL Server Mobile connects, the subscription...

Repro : ** note: if you will be trying this repro – please remember to alter the script to suit your environment (Example: @web_synchronization_url) ** SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tbl_Thisisareallylongtablenametoemphisetheissue...