SQL Server Performance

replication error Error at parameter 34 during dat

Discussion in 'Performance Tuning for SQL Server Replication' started by ranjandba, Jun 20, 2007.

  1. ranjandba New Member

    I m getting a below error in my replication its a transacional replication ... "Error at parameter 34 during datastream processing of parameterized command." any input wht the reason for this error and how to sort it out ...?
  2. MohammedU New Member

    First enable agent logging...to get more info...

    HOW TO: Enable Replication Agents for Logging to Output
    Files in SQL Server.
    http://support.microsoft.com/?id=312292




    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. ranjandba New Member

    did that but the outputfile is full of jumble characters... <br /><br /><br />eg - <br />Last transaction timestamp: xxxxxxxx<br />Transaction seqno: xxxxxxxxxxx<br />Command Id: 355<br />Partial: 0<br />Type: 30<br />Command: &lt;&lt<img src='/community/emoticons/emotion-4.gif' alt=';p' />arameterized command&gt;&gt;<br /><br />any imput to decode this ..? or any further recomendation to sort out the issue ?
  4. MohammedU New Member

    You may need to call Microsoft PSS to decode it [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Can you post Publisher, distirbutor and subscribers sql builds?<br /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided “AS IS” with no warranties for accuracy.<br />

Share This Page