May 26, 2009 at 8:25 am
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?
May 26, 2009 at 9:04 am
Follow the microsoft article below to manually remove the replication
http://support.microsoft.com/kb/324401
hope it helps
-Sat:-)
Cheer Satish 🙂
May 26, 2009 at 9:51 am
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?
May 26, 2009 at 9:55 am
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.
May 26, 2009 at 10:34 am
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
June 16, 2014 at 2:19 am
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