SQL's Corner

Replication: Stream_Blob_Columns enabled by default when Filestream is enabled

https://support.microsoft.com/kb/2647118

Author: clsilva 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

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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,...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva Date: 08/08/2011

Replication: Merge Performance Tip

Problem: Publisher: SQL Server 2008 Subscriber: SQL Server Compact 3.5 Merge Replication Performance...

Author: clsilva Date: 08/08/2011

Replication: Fake Conflicts?

One problem that is hard to resolve / understand is fake conflicts within a merge replication...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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:    ...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva Date: 01/25/2010

SQL Server: SQL Server and Windows “End of Support” Dates

https://blogs.msdn.com/psssql/archive/2010/01/08/important-sql-server-and-windows-end-of-support-date...

Author: clsilva 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...

Author: clsilva Date: 01/07/2010

Replication: Transactional Replication Over WAN

A lot of users have wondered about the performance latency transactional replication suffers over...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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,...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva Date: 05/13/2009

Replication: Transactional Replication Performance Issue

one possible cause... There are many factors that can influence the performance on a transactional...

Author: clsilva Date: 05/06/2009

Replication: Distribution Cleanup

Manual Cleanup What can one do when the distribution cleanup job is unable to cleanup the...

Author: clsilva Date: 05/04/2009

SQL Server Books

Books I recommend: SQL 2005: Inside Microsoft® SQL Server 2005: T-SQL Querying by Itzik Ben-Gan ,...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva 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...

Author: clsilva Date: 04/28/2009

Replication: Sysmergearticles and Error 208

Invalid object name "dbo.sysmergearticles": I have seen issues on Forums where people state that...

Author: clsilva Date: 04/27/2009

Next>