Replication error in Snapshot publication -- sql server replication

Johnny Hu
2/19/2005 9:41:06 PM

Hi,

I built a database replication between 2 SQL 2000 servers in our domain
(both with SP3). I used snapshot publication and it worked for a few days.
But one day the Distribution Agent task failed with the following,

Error message:
Line 95: Incorrect syntax near 'DROP TABLE '.

Error details:
Line 95: Incorrect syntax near 'DROP TABLE '.
(Source: CAWLKW05 (Data source); Error number: 170
---------------------------------------------------------------------------------------------------------------
Line 102: Incorrect syntax near 'SELECT * INTO '.
(Source: CAWLKW05 (Data source); Error number: 170
---------------------------------------------------------------------------------------------------------------

Please suggest

Thanks

Hilary Cotter
2/20/2005 11:17:04 AM

can you script out the schema of the articles you are replicating and post
them here along with your publication script?

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

sql server replication : Replication error in Snapshot publication