Post reply

Replication with data

  • August 22, 2005 at 9:34 pm

    #87323

    I have transactional replication on SQL Server 2000 with service pack 3a and hot fixes, if the table gets data with < or > symbols, the replication fails with syntex error. Did anybody noticed this? or  is this some bug?

    Please help!

     

  • August 23, 2005 at 10:44 am

    #584287

    I tried few more tests.

    If the table name is with space. i.e created table [Titles Type] from Title in pubs and used tranasctional replication on other server. Replication successful. Now change data to one of the varchar field  by adding "<High Priority>" gives syntex error. It sems the combination of table name with space and data with < > symbols. Is this bug or something?

    I can not change table name as it is getting used in all over the application. I am thinking to put instead of trigger to escape < or > symbols to get it work. But this is extra load on database. 

    Is there some fix available or is there any other way?

    Let me know if somebody come accross this problem and resolved it.

     

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply