This is a very weird problem. I found out that it only happens to my development and test environment but when it is ported to the production...
Sorry that was the console version. My sql version is 8.00.760 (SP3)
Version 5 (Build 2195: Service Pack 3) Collation for text and varchar are all set to -> SQL_Latin1_General_CP1_CI_AS
Everytime it happens the profiler application name - Replication Distribution History and will appear with text data usually looks something like :...
Ok I managed to put the replication output into a file and found that the parameter of text datatype used to store xml data which got replicated was...
sorry a few mistakes in my previous post. I meant one of the paramenter used in the replication script is of Text datatype where the data is XML...
As mentioned in my previous posting, I uses script for my replication. One of the script which I used is of Text datatype where the data is in XML...
Ok I manage to capture the exact error frm the Action Message that appears in a sequence: - Execution of individual commands succeeded. NOTE: The...
There is no exact error except it just kept saying "Execution of Individual Commands" and it will retries many times if it hasn't succeed until...
I set up transactional replication on SQL 2K database. Some of the tables are replicated using store procedures while others are replicated using sql...
Separate names with a comma.