replication and 'syntax error near E'

I use SQL2005 with bunch of stored procedures. All worked fine. Then I set u
p
push transactional replication with sqlexpress so all agent were running on
publisher. Replication ran without errors and replicated articles. After som
e
time (about 1 hour) few stored procedures failed with 'Incorrect syntax near
E' error.
When I remove replication same stored procedures work without any error.
Every time when replication is set up error occurs on same procedures.
Stored procedures work with cursor, create and update temporary tables using
EXEC statement with dinamicaly build query.
When I remove replication same stored procedures work without any error, so
I guess it's not SQL.
I havent found nothing on this on Technet, MSDN or on internet.
Thank you for any hint.Enable logging to see exactly what is causing this error. Refer to this kb
article for more info on how to enable logging.
http://support.microsoft.com/kb/312292/en-us
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"janez" <janez@.discussions.microsoft.com> wrote in message
news:18698F9A-84F2-446F-9175-0B753EA01A99@.microsoft.com...
>I use SQL2005 with bunch of stored procedures. All worked fine. Then I set
>up
> push transactional replication with sqlexpress so all agent were running
> on
> publisher. Replication ran without errors and replicated articles. After
> some
> time (about 1 hour) few stored procedures failed with 'Incorrect syntax
> near
> E' error.
> When I remove replication same stored procedures work without any error.
> Every time when replication is set up error occurs on same procedures.
> Stored procedures work with cursor, create and update temporary tables
> using
> EXEC statement with dinamicaly build query.
> When I remove replication same stored procedures work without any error,
> so
> I guess it's not SQL.
> I havent found nothing on this on Technet, MSDN or on internet.
> Thank you for any hint.|||Thanks for advice. It will be usefuul in further analysis of the cause.
By trying I found setting scheduled snapshot to cause error. Transactional
replication with only initial snapshot works without any problem.
"Hilary Cotter" wrote:

> Enable logging to see exactly what is causing this error. Refer to this kb
> article for more info on how to enable logging.
> http://support.microsoft.com/kb/312292/en-us
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "janez" <janez@.discussions.microsoft.com> wrote in message
> news:18698F9A-84F2-446F-9175-0B753EA01A99@.microsoft.com...
>
>