Replication

murge process could not clean up the subscription
error Message:- The merge process could not clean up the subscription to 'WWW':'MSA:'MSA'. Error Details:- The merge process could not clean up the subscription to 'WWW':'MSA:'MSA'. (Source: Merge Replication Provider (Agent); Error number: -2147200965) ---------------------------------------------------------... 19 Feb 2007 03:30

Huge MSrepl_commands table
On a SQL 2005 distributor we are seeing very high I/O levels and high cpu when the distribution clean up job runs. The MSrepl_commands table has some 8+ million rows. The MSrepl_transactions table has very old dates in it and I'm wondering if the clean up job isn't doing what it's supposed to do. Is there a ... 14 Mar 2007 10:38

SQL 2005 transaction repl verbose logging location
I have primary key duplication issues on brand new snapshot of data, where subscriber is just a read-only reporting server. I am trying to turn on verbose history agent profile, but don't know specifics of doing this. Do I do it on the distribution agent or at the subscriber? Also, where does it store the informati... 15 Feb 2007 23:29

Configuring Distributor
I keep getting the error message: An error occurred during decryption. There is no remote user 'distributor_admin' mapped to local user '(null)' from the remote server 'repl_distributor'. Changed database context to 'master'. (Microsoft SQL Server, Error: 15466) I have tried a local server account (as BOL ... 19 Feb 2007 11:31

Cannot Subscribe Using Windows Synchronization Manager
Hi, I'm using two instances of SQL Server 2005 Developer Edition (SP2) on the same machine. One instance is Publisher and Distributor and the other is Subscriber. When I try to use Windows Synchronization Manager to subscribe to the publication, I get this error: The SQL Server publication uses features that ... 9 Feb 2007 16:11

Unable to create transactional replication subscription - authenticationissue?
Hi everyone, hopefully someone here can shed light on this, I've run out of ideas.... I'm running two SQL2005 SP1 servers here, Windows authentication only, so far everything works fine. I'm managing them either through the Management studio on my laptop as well as directly. I want them to replicate data u... 8 Feb 2007 11:42

The job step improperly defined error
I created a transaction replication in SQL 2005, and replication generated log reader and distribution jobs. They are running fine. For example, the “replication transaction-log reader” job defined as following. Type: replication transaction-log reader Run as SQL Agent Service account Command: -Publish... 29 Jan 2007 09:52

Log Reader Error
My LogReader Agent is failing, with the following errors: 1) The process could not execute 'sp_replcmds' on 'YKCLNSE'. 2) Execution of filter stored procedure 1364915934 failed. 3) Logreader failed to construct replicated command from LSN {00035e6f:00002a45:0004}. I saw a post from Adam Sewell on this same pr... 14 Jan 2007 07:17

Could not load file or assembly 'Microsoft.SqlServer.BatchParser'
Every time i accessed my web service I got this error: Could not load file or assembly 'Microsoft.SqlServer.BatchParser' or one of its dependencies. An attempt was made to load a program with an incorrect format. I had no reference to the 'Microsoft.SqlServer.BatchParser' in my web service, why i got this erro... 10 Jan 2007 21:48

Deadlock between Distribution Agent and Distribution Agent Cleanup
I am experiencing this problem. Deadlock of these two M$ stored procedures : sp_MSget_repl_commands (Executed by the Distribution Agent --pull subscriber ) and sp_MSdistribution_cleanup (Executed by the Distribution Agent Cleanup job) the offending queries are : From sp_MSdistribution_cleanup: DELETE... 22 Dec 2006 14:16