QueueReader Error

• Graeme100

  SSCrazy Eights

  Points: 8054

  More actions

  March 21, 2006 at 2:02 am

  #103126

  Hi Guys and Gals,

  Has any one had any experience of the following problem.

  I've added a subscriber to a publication (Transactional Rep with Queued Updating). When I update data on the subscriber, the queue reader fails with

  ODBC Error:Could not change the Publisher because the subscription has been dropped. Use sp_subscription_cleanup to clean up the triggers

  The subscription is still in the publication. I've reapplied the subscription but the same thing happens.

  I have another subscription to the publication and this works ok and the changes from this subscriber will get distributed to the suspect subscriber.

  Has any one got any thoughts on this ?

  Many Thanks

  Graeme

• Graeme100

  SSCrazy Eights

  Points: 8054

  More actions

  March 21, 2006 at 3:59 am

  #627818

  I seemed to have found the problem.

  The server had been built with the wrong and then the name was changed to what it should be....without me knowing

  Discovered this by using sp_helpserver

  All I had to do was run the following

  sp_dropserver 'old server name'

  sp_addserver 'new server name', 'local'

  And the stop and start the sql service. This seems to have solved the queuereader problem

  Cheers..Graeme