SQL's Corner
Replication: Stream_Blob_Columns enabled by default when Filestream is enabled
https://support.microsoft.com/kb/2647118
Date: 01/10/2012
REPLICATION: Oracle publication triggers sends data for non-published columns when replicating with Microsoft SQL Server
https://support.microsoft.com/kb/2310152
Date: 01/10/2012
REPLICATION: Load Test Platform for Merge Replication
Zen4Sync is all about providing an Orchestration and Load Test platform able to validate any SQL...
Date: 12/15/2011
Replication: Watch out for STREAM_BLOB_COLUMNS when setting up replication on your SQL 2008 + server
When setting up merge replication on your SQL 2008 + server, please be careful with the parameter...
Date: 10/31/2011
Replication: If sql_variant column includes a value with new datetime type, the value is replicated as base type nvarchar even if schema option 0x200000000 is not set
Problem: If sql_variant column includes a value with new datetime type, the value is replicated as...
Date: 10/20/2011
Replication: XML data loss occurs when Merge agent fails with Violation of Foreign Key
Problem: Consider the following scenario: You use a merge publication operation to replicate XML...
Date: 09/28/2011
Replication: What is the difference between Database Compatibility Mode and Publication Compatibility Mode
Database Compatibility Mode: Compatibility level affects behaviors only for the specified database,...
Date: 09/28/2011
Replication: Snapshot agent execution causes system Available Memory to drop to 0 and possibly fail
Problem: While running the snapshot agent, the available memory of the server goes down to 0 and...
Date: 09/28/2011
Replication: Error "You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels" generated when altering published table columns
Problem: Error "You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ...
Date: 08/08/2011
Replication: Merge Performance Tip
Problem: Publisher: SQL Server 2008 Subscriber: SQL Server Compact 3.5 Merge Replication Performance...
Date: 08/08/2011
Replication: Fake Conflicts?
One problem that is hard to resolve / understand is fake conflicts within a merge replication...
Date: 06/29/2011
Note to all Readers
Seems like there was an issue with the comments for this blog - I wasn’t getting notified and...
Date: 06/08/2011
REPLICATION: My distribution agent generates a dump when replicating with my Oracle Subscriber
PROBLEM: I have a SQL Server 2005 replicating with an Oracle 11 subscriber. After installing the...
Date: 06/08/2011
Replication: The row was not found at the Subscriber when applying the replicated command - Error 20598
Problem: I have a transactional replication topology that consists of SQL 2005 and SQL 2000. I...
Date: 06/08/2011
Replication: Unable to Synchronize subscribers via Web Synchronization
Problem: The upload message to be sent to Publisher 'XXX' is being generated The merge process is...
Date: 05/12/2011
Replication: SQLCESALOG: Is it possible to change the number of files and the size of each?
Yes it is. Following the following KB article: ...
Date: 05/26/2010
Replication: Merge Fails with error : “The process could not increment the lineage version”
I have come across this interesting issue in which we have the following scenario: Merge Replication...
Date: 03/04/2010
Replication: My merge agent keeps “dropping and creating” my newly added articles!!!
Problem: Consider the following scenario: You add a new article(s) to an existing publication in...
Date: 02/02/2010
Replication: The schema script could not be propagated
Problem: I create a SQL Server 2005 replication topology on my Windows 2003 server. Everything...
Date: 01/25/2010
SQL Server: SQL Server and Windows “End of Support” Dates
Date: 01/18/2010
Replication: Access Permission Error when generating Dynamic Snaphot
Problem: My snapshot agent fails to create a dynamic snapshot for a subscriber in my Merge...
Date: 01/07/2010
Replication: Transactional Replication Over WAN
A lot of users have wondered about the performance latency transactional replication suffers over...
Date: 01/04/2010
Happy New Year Readers
Happy New Year Readers! May the best moments of 2009, be the worst of 2010 are my wishes to you all...
Date: 01/04/2010
Replication: Help! I lost a replication system stored procedure
“Could not find stored procedure MSMERGE_INS/UPD/DEL_SP_XXXXXXXXXX” If you have replication set up...
Date: 11/25/2009
Replication: Merge Filters – optimize optimize optimize
I noticed that many people overlook optimizing their filters in a merge replication topology. This...
Date: 11/16/2009
Replication: Partitioned snapshot fails with "Incorrect syntax near" message when article name has more than 40 characters
Repro: ** note: if you will be trying this repro – please remember to alter the script to suit your...
Date: 11/12/2009
Replication: Snapshot does not generate correctly the partition scheme when you add a view to the publication
Problem: SQL Server 2005: I have created a database that contains various file groups and assigned...
Date: 10/27/2009
Replication: Configuring Remote Distributor Generates the following error: “"Could not find stored procedure 'sp_replcheck_qv'”
Problem: When I try to configure a SQL Server 2008 to be a remote distributor of my SQL Server 2005...
Date: 10/26/2009
Replication: Replication Monitor only shows a red X after upgrading from SQL 2000 SP4 to SQL 2008 SP1
Problem: When I upgrade my SQL Server 2000 SP4 to SQL 2008 SP1, I am unable to verify my replication...
Date: 09/24/2009
Replication: Identity column seeded incorrectly if two or more merge agents try to adjust the publisher range in parallel
Problem: SQL Server 2008 Merge replication with automatic identity range handling. Suddenly, every...
Date: 09/23/2009
Replication: The merge process could not query the last sent and received generations.
Problem: Topology: - Merge replication with statically-filtered publications. - 2 publishers,...
Date: 09/23/2009
Replication: a few Questions and Answers
Here are some interesting questions, and their respective answers, which may clarify a few things in...
Date: 09/14/2009
Replication: The lineage parameter is shorter than the minimum required size
Problem: I created/altered a (new) record on Subscriber B which I then synchronized with my...
Date: 09/14/2009
Replication: An error occurred while reading the .bcp data file for the 'MSmerge_rowtrack' article
Problem: I have a random issue with a few of my Compact Edition subscribers. The issue that occurs...
Date: 07/29/2009
Replication: Infinite Retention Period Causing Performance Issues
A little explanation before explaining how to resolve this issue: The retention period for...
Date: 06/22/2009
Replication: Cannot Alter Column ‘column_name’ because it is Replicated
Problem: I wanted to change the schema of a table which was published in my replication topology. I...
Date: 06/19/2009
SQL Server Performance Analysis Part V
PART V: "How To" get down to whatever is bringing SQL to its knees... At this point, following the...
Date: 06/04/2009
Replication: Header information is either corrupted or missing
I have seen this issue many times and decided to share my experience and how this issue may be...
Date: 05/13/2009
Replication: Questions about Upgrades and Mixed Technologies
I have spoken to many people in regards to three common questions and therefore thought it may be...
Date: 05/13/2009
Replication: Transactional Replication Performance Issue
one possible cause... There are many factors that can influence the performance on a transactional...
Date: 05/06/2009
Replication: Distribution Cleanup
Manual Cleanup What can one do when the distribution cleanup job is unable to cleanup the...
Date: 05/04/2009
SQL Server Books
Books I recommend: SQL 2005: Inside Microsoft® SQL Server 2005: T-SQL Querying by Itzik Ben-Gan ,...
Date: 04/29/2009
Replication: Non-convergence on Merge Replication
one possible cause... I had worked on an issue which I found quite interesting so decided to post it...
Date: 04/29/2009
Replication: Snapshot files removed after being Generated
Snapshot files for a transactional publication are immediately removed after being generated by the...
Date: 04/29/2009
SQL Server Performance Analysis Part IV
PART IV: "How To" get down to whatever is bringing SQL to its knees... At this point, one should...
Date: 04/29/2009
SQL Nexus – The Tool
After writing about "How to analyse SQL Server Performance", I decided to write a post about SQL...
Date: 04/28/2009
Questions and Topics
If you have any questions in regards to any issue related to SQL / SQL Replication or would like me...
Date: 04/28/2009
Replication: Sysmergearticles and Error 208
Invalid object name "dbo.sysmergearticles": I have seen issues on Forums where people state that...
Date: 04/27/2009