Replication status shows error

• ruben.ortiz

  Valued Member

  Points: 59

  More actions

  July 21, 2010 at 9:55 am

  #235524

  Hi all

  Im testing SQL SERVER 2005 replication capabilities in a test environment:

  One DELL PowerEdge SC1425

  Vwmare ESXi 4.0

  Two hypervisors as:

  MV 1)

  WIN2k3 ENT 64bits

  SQL SERVER 2005 standard edition SP3 64 bits

  IP 10.0.0.161

  Acts as Publisher and Distributor

  MV 2)

  WIN2k3 ENT 64bits

  SQL SERVER 2005 standard edition SP3 64 bits

  IP 10.0.0.162

  Acts as Subscriptor

  I did correctly every step to make publisher, distributor and subscritpor.

  I started synchronization agent first only with this articles:

  1) Tables

  And everything was ok.

  Then, with

  2) Tables and Views

  And everything was ok.

  But when I did

  3)Tables Views and Stored Prodedures

  Synchronization Monitor shows always the same error:

  "Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon."

  I understand there is a problem with some Stored, but I cannot find it! Because Replication Monitor doesn't show exactly which Stored Procedure is.

  Output of error of Replication Monitor:

  Command attempted:

  -- =============================================

  -- Author:Eloi Poch

  -- Modified By: Alberto García

  -- Create date: 20 Octubre 2009

  -- Modification Date: 23 Febrero 2010

  -- Description:Retorna la quantitat desitjada de continguts

  --dels tipus indicats i amb el multimedia seleccionat

  --de manera paginada

  --Si també volem les noticies sense imatges se li ha

  --de pasar un 0 entre els valors de @IdTipoMultimedia

  -- Modification: Se li ha de passar un tercer sipus

  -- de contingut i de multi

  (Transaction sequence number: 0x001AB9D30000023D006B00000000, Command ID: 1469)

  Error messages:

  Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. (Source: MSSQLServer, Error number: 319)

  Get help: http://help/319

  Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. (Source: MSSQLServer, Error number: 319)

  Get help: http://help/319

  But Where this Replication monitor informs you of which Stored is? Or how can i Find it?

  Thanks a lot guys

• Roy Ernest

  SSC-Dedicated

  Points: 38780

  More actions

  July 22, 2010 at 9:46 am

  #1196946

  There is an article explaining how to find the object from replication error

  http://www.sqlservercentral.com/blogs/robert_davis/archive/2010/03/27/Making-Sense-of-Replication-Errors-in-Replication-Monitor.aspx

  -Roy