–by Liwei Yin, Microsoft SQL China Support Assume you have CDC enabled for a table with text/ntext column. 1 You moidfy the colum type from text/ntext to varchar(max)/nvarchar(max) 2 Then you do an update to the column thereon, tried to assign a large size (more than 8000)value to the column, the CDC may fail and
Read More »
by Chris Skorlinski, Microsoft SQL Server Escalation Services Oracle Publishing, now deprecated in SQL Server 2014, provides ability to use Oracle server as a Transactional Replication Publisher to a Microsoft SQL Server subscriber. Oracle Publishing Overview http://technet.microsoft.com/en-us/library/ms151229.aspx This feature was as designed as an Oracle to Microsoft SQL Server migration tool. Other customers used Oracle
Read More »
ReplTalk ReplTip – Replication Agent fails with “unable to start correctly” Taiyeb Zakir Microsoft SQL Server Escalation Services When you have a large number of SQL Server Agent or Replication Agent Jobs running, some of the Jobs may not even start. You might see an error like this in the Event log: “The application was
Read More »
How to fix SQL 2008 R2 Replication objects not being created on Subscriber Chris Skorlinski Microsoft SQL Server Escalation Services Just a heads up if you are still running any version of SQL Server prior to SQL Server 2012 SP1 for Transactional Replication and the following hold true: 1) Use ‘initialize with backup’ To initialize
Read More »
ReplTip – Subscribe to “all” restriction using “Initialize with backup” Chris Skorlinski Microsoft SQL Server Escalation Services I ran into a couple of challenges using the Backup\Restore method to setup a SQL Server Replication Subscriber. In particular, using this method you are unable to subscribe or un-subscribe to an individual article. Using Backup\Restore you mush
Read More »