[dba-SQLServer] SQL Server - Transactional Replication - Syntax Error or Access Violation

Paul Hartland Paul.Hartland at orridge.co.uk
Tue May 2 05:31:48 CDT 2006

To all,

I have had Transactional replication running without a problem now for
at least the last couple of months, however I have came in this morning
to find it has stopped working with the failure message being Syntax
Error or Access Violation.  If a double click the error I get a box up
saying the Publisher name, Agent, Publication & Subscription which are
ok.  Then a last command which says :

{CALL sp_MSdel_tblPre-JobWages (N'A', N'WD', N'Checker',
Transaction sequence number and command ID of last execution batch are
0x000372D500000E79000F00000000 and 1. 

Error Message: Syntax error or access violation.

Error Details: Syntax error or access violation
                    (Source: AL-MAN (ODBC); Error number:  37000)

Anyone any ideas on what could be happening ?

I notice the error occurs with something to do with tblPre-JobWages, but
this table hasn't been changed in anyway for over 7-9 months now (before
I even started the Transactional Replication)....

Any help on this would be greatly appreciated.

Database Designer/Programmer
paul.hartland at orridge.co.uk
DDI - 01922 472031
Mobile - 07730 523179


*  This message is confidential.
*  This email, its content and any files transmitted with it are intended solely for the addressee and may be legally privileged and/or confidential.
*  Access by any other party is unauthorised without the express written permission of the sender.
*  If you have received this email in error you may not copy or use the contents, attachments or information in any way and any review, use, dissemination, forwarding, disclosure, alteration, printing of this information is strictly prohibited. Please destroy it and notify the sender via return e-mail.
*  This email has been prepared using information believed by Paul Hartland to be reliable and accurate, but the company makes no warranty as to accuracy or completeness. In particular the author does not accept responsibility for changes made to this email after it was sent.
*  Any opinions expressed in this document are those of the author and do not necessarily reflect the opinions of the company or its affiliates.

The Orridge web site can be found at:

More information about the dba-SQLServer mailing list