locked
can't delete subscription at subscriber - error 'Invalid column name', publisher does not exist RRS feed

  • Question

  • Hi dear all,

    It's sql server 2008. The publisher does not exist. I tried several stored procedures at subscriber, but always received:

    "Could not delete the subscription.
    An exception occurred while executing a Transact-SQL statement or batch.Invalid column name 'job_step_uid'. (.Net SqlClient Data Provider)"

    Tuesday, November 2, 2010 3:02 PM

All replies

  • Hi,

    Could you please elaborate a bit? How did you delete the subscription?

    Pull subscriptions can be deleted programmatically using replication stored procedures. The stored procedures used will depend on the type of publication to which the subscriptions belongs.

    I recommend that you ask your question in the SQL Server Replication forum.

    For more information, please see:

    How to: Delete a Pull Subscription (Replication Transact-SQL Programming)

     

    Thanks,

    Ai-Hua Qiu


    Constant dropping wears away a stone.
    Monday, November 8, 2010 3:06 AM
  • Hi,

     I tried all stored procedures concerning deleting subscription, but whatever I did always received:

    "Could not delete the subscription.
    An exception occurred while executing a Transact-SQL statement or batch.Invalid column name 'job_step_uid'.

    Thanks,

    Danka


    danka
    Wednesday, November 10, 2010 8:29 AM