subscription error

  • I had to blow away my publications and replications. When I rebuilt them, I get the error: "Cannot use DROP VIEW with 'dbo.AVIView_Software' because 'dbo.AVIView_Software' is a table. Use DROP TABLE. (Source: MSSQLServer, Error number: 3705)

    Get help: http://help/3705". What d I need to do to completely remove the publications and replications?

  • Follow the microsoft article below to manually remove the replication

    http://support.microsoft.com/kb/324401

    hope it helps

    -Sat:-)

    Cheer Satish 🙂

  • I have 2 Publications/Subscriptions. Using the GUI, I delete those, then disable the Distribution. I then rebuild the Distribution and the Publications/Replications. One works beautifully, the other generates the error. The one that works is set for refresh every 15min. The one that fails is set for refresh once a day. Does the GUI not do what the steps in the article do?

  • Thanks. That link led to the fix. I had to change the machine.config file though. I tried to change the web.config but that didn't work for some reason.

  • I had to drop 3 views to get it working:

    drop view dbo.AVIView_Sensors

    drop view dbo.AVIView_Software

    drop view dbo.AVIView_LeafNode

  • Hi experts,

    I have similar error but different scenario...

    I want to replicate a view that is created from tables from another server. Let say I have 3 servers, svrA, svrB and svrC. The view, viewB, is in svrB. viewB is created from 2 tables from svrA. This viewB is then replicated to svrC.

    I cant make it work because it throws me an error like here.

    Is what i do correct ? I just want to make single data source so that i dont have to modify many tables from many servers...

    Finally, How can i solve this error ?

    thanks alot

Viewing 6 posts - 1 through 5 (of 5 total)

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