Re: trans repl - distribution agent doesn't deliver transactions

From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 12/17/04 

Date: Fri, 17 Dec 2004 15:06:47 -0500

what happens if you connec to the subscriber using query analyzer and issue
this command?

CALL sp_InsertOrder (214763321, 'Install ', 0,' acÇ@?pwà@?', -1, 0)} 

-- 
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"OJ" <anonymous@discussions.microsoft.com> wrote in message 
news:108301c4e3eb$2fb97700$a601280a@phx.gbl...
Just to add something... Meanwhile I turned on verbose
logging of distribution agent, and I noticed, here and
there, several errors in this log file:
37000 Line 1: Incorrect syntax near '2004-12-15
00:00:00.000'. 170
Last transaction timestamp: 0x000008da0004fa9b002c00000000
Transaction seqno: 0x000008da0004fa9b002c
Command Id:  19
Partial: 0
Type: 0
Command:
Failed command = {CALL sp_InsertOrder
(214763321, 'Install  ', 0, 'acÇ@?pwà@?', -1, 0)}{.......
Last transaction timestamp: 0x000008da0004fa9b002c00000000
Transaction seqno: 0x000008da0004fa9b002c
Command Id:  18
Partial: 0
Type: 0
Command: {CALL sp_InsertOrder(214763321, 'Operatio ',
{ts '2004-06-16 00:00:00.000'}, 1, -1, {ts '2003-05-19
00:00:00.000'}, {ts '2003-06-04 00:00:00.000'}, 0)}
***************************************************
What I don't understand is, how syntax errors, if any,
can stop distribution agent from replicating
transactions...
OJ

Relevant Pages

  • Re: Distribution Agent fails with error: Line 1: Incorrect syntax near ,null,
    ... You mentioned manipulating the command in the msrepl_commands table. ... transaction capable: 2 ... Last transaction timestamp: 0x000004810000069f000900000000 ... Transaction seqno: 0x00000481000006e70001 ...
    (microsoft.public.sqlserver.replication)
  • Re: Asynchronous Stored Procedure Never Returns - Help?
    ... private void HandleCallback ... SqlCommand command = result.AsyncState; ... the transaction completes I get back to the point just before I clicked "OK" ... par = cm.CreateParameter; ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Transactions without setting OleDbCommand.Transaction property
    ... roundtrip since we will batch the first Begin Transaction command with the ... track of the transaction, so if you leak it we will explicitly roll it back ... "Osvaldo Bisignano" wrote in message ... > On the other hand, I think that when you run an ExecuteNonQuery, an ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Distribution Agent fails with error: Line 1: Incorrect syntax near ,null,
    ... > You mentioned manipulating the command in the msrepl_commands table. ... > transaction capable: 2 ... > Last transaction timestamp: 0x00000481000006e7000100000000> Transaction seqno: 0x00000481000006e70001> Command Id: 2 ...
    (microsoft.public.sqlserver.replication)
  • Re: C# and SQL - how to insert few lines together
    ... You should dispose of your connection and transaction objects when you are no longer using them. ... In your example you are iterating 2 times and executing the command each time without adjusting the parameter's value. ... >>> unique and can not be sold twice ...
    (microsoft.public.dotnet.languages.csharp)