In my Distributor To Subscriber History I get the following error:

Command attempted:
  (Transaction sequence number: 0x0018E94F0000207A006200000000, Command ID: 59)

Error messages:

  Incorrect syntax near '9'. (Source: MSSQLServer, Error number: 102)
  Get help: http://help/102

It's a transactional replication with a pull subscription.

How do I locate this syntax error?


I found out where the syntax error is. It's in a Address_2.sch file in the snapshot folder.

The first line is 9drop Table [dbo].[Address]

If I remove the "9" i just get another error: Could not find stored procedure 'd'

This error I can't resolve.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.