all groups > sql server replication > september 2006 > threads for september 29 - 30, 2006
Filter by week: 1 2 3 4 5
Merge Replication Failure
Posted by Samuel Shulman at 9/30/2006 9:55:02 PM
I was adviced to turn Logging on to spot the problem with the consistantly
failing Merge Replication
Below is the end of the log. I you need the entire log I will add it
Percent Complete: 31
select * from "dbo"."tblUser" where 1 = 2
Bulk copying data into table 'tblSolsFeeEarner'
[9/30/20... more >>
Login Problem
Posted by Samuel Shulman at 9/30/2006 9:44:48 PM
I just tried to create a Transactional Replication and it failed because the
Login for sa failed...
I assume that the destination server (for Push Subscription) doesn't
recognize the sa of the Distributor
What can be done to solve that (when running the wizard I wasn't given any
chance... more >>
Table ms_MergeContents
Posted by Samuel Shulman at 9/30/2006 9:23:55 PM
Hi
I noticed this table which was added after I added the first publication
Is it normally necessary to include it for replication? It seem to forever
get bigger...
Thank you,
Samuel
... more >>
Trans ^ Merge Repl Scheduling in SMS 2005
Posted by LPR-3rd at 9/29/2006 9:41:56 AM
I cannot find where to change the 'schhedule' in SMS 2005. I can go to
EM & do it...by finding it in the distribution agents.
Do I have to navigate to the job in the SQL Agent->Jobs folder??
Larry...
... more >>
Merge replication failure
Posted by Samuel Shulman at 9/29/2006 12:00:00 AM
After working for about 30 minutes (delivering the snapshot) the replication
failed
I checked the Session details of the subscription and I found Action Message
saying the 'The process could not deliver the snapshot to the Subscriber.'
In the error information under Data Source I found the... more >>
|