• Hi Robert,

    My name is Kim, I am going thru the same issues that you had before, I was just wondering if yours worked out?  I am having problem with the insert statement.

    I have set up two servers, I was able to update and delete but I am not able to insert any rows either on Publiser or Subscriber.  I am using Merge repl. Sql server 2000, when I tried to insert a row in a table, and I got error msg 'Syntax error converting from a character string to uniqueidentifier', then I went to the table trying to delete the rowguid, but I keep getting the error msg "can't alter the table 'table_name' because it is being publised for replication".  So I went to the Publication folder to delete the publications in the 1st server (I have 2 different publications) I was able to delete the first one, but I am unable to delete the second one, I keep getting error msg 'error 3724: can't drop the store procedure 'procedure_name' because it is published for replication', so I tried to stop and start the 1st server, then tried to delete it, it didn't work either....I desperately am seeking for help, I am not sure what to do now so that I can run the insert statement???

    Please help!

    Thanks in advance for your help!

     

    Kim