See all products »
Curah! curation service
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Compatability & Converters
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
For small and midsize businesses
For IT professionals
For technical support
For home users
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Replication - Mobile
Browse by Tags
REPLICATION: Oracle publication triggers sends data for non-published columns when replicating with Microsoft SQL Server
10 Jan 2012
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 OLEDB driver for Oracle 11, a minidump is created every time the distributor tries to connect to Oracle: Distrib.exe crashes with STACK_OVERFLOW exception. The issue occurs while initializing the...
8 Jun 2011
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 the new data files to their respective file group. I also created a partition function and partition scheme (using the file groups created). I then created a transactional publication in which...
27 Oct 2009
Note to all Readers
Seems like there was an issue with the comments for this blog - I wasn’t getting notified and hence never got to respond. My apologies to all those that commented and never got a reply. If you do have a comment, please do not hesitate to e-mail me by selecting "e-mail Blog Author" Thanks...
8 Jun 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 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 at the Subscriber when applying the replicated...
8 Jun 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 , not for the entire server. Compatibility level provides only partial backward compatibility with earlier versions of SQL Server. Use compatibility level as an interim migration aid to work around...
28 Sep 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 snapshot may even fail. Should the snapshot complete, the memory is released very slowly. Cause : This is because in the current design (SQL 2005 and higher), snapshot agent uses SNAC BCP provider...
28 Sep 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 isolation levels " generated when altering published table columns in a transactional replication. Cause : Unable to alter columns on Published database if using any isolation level besides...
8 Aug 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 base type nvarchar even if schema option 0x200000000 is not set during the application of the SNAPSHOT (only). After the snapshot has been applied, if you execute the command to verify the property...
20 Oct 2011
Replication: Transactional Replication Performance Issue
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 performance latency. Once the latency was pinpointed...
6 May 2009
Replication: Snapshot files removed after being Generated
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. Problem : The snapshot files for a transactional...
29 Apr 2009
Replication: Issue with setting up Transactional Replication with Updatable Subscribers and NFR Triggers
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 and the changes are propagated onto the publisher...
26 Jul 2010
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 / 2000 instance, I get the following error generated when using the GUI wizard: Could not find stored procedure 'sp_replcheck_qv' This prevents me from adding a SQL Server 2008 instance to...
26 Oct 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 removed the table from two publication in which it was being published and tried changing the column name. This failed with the following error: Caution: Changing any part of an object name could...
19 Jun 2009
Replication: Distribution Cleanup
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 process. However should we need to clean the old...
4 May 2009
Replication: Transactional Replication Over WAN
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 of implementation: Should you notice performance...
4 Jan 2010
© 2014 Microsoft Corporation.
Privacy & Cookies