SQL Replication Problem - References between Views and Tables

Posted on 2009-02-13
Last Modified: 2012-05-06
Hello experts,

I wanted to install a replication of a db between a productive and backup server.
So I made a backup of the current DB from the productive server and restored that on the backup server.
Since we already had a merge replication publisher on the productive server, on the backup server  I created a subscription to that merge replication.
But when I started the synchronisation I received the following error:


2009-02-13 10:21:41.888 The schema script 'Historie_25.sch' could not be propagated to the subscriber.
2009-02-13 10:21:41.997 Category:NULL
Source:  Merge Replication Provider
Number:  -2147201001
Message: The schema script 'Historie_25.sch' could not be propagated to the subscriber.
2009-02-13 10:21:41.997 Category:NULL
Source:  Microsoft SQL Native Client
Number:  3729
Message: Cannot DROP TABLE 'dbo.Historie' because it is being referenced by object '_Historie'.


Now it makes total sense that you cannot drop a table when it's still referenced.
What can I do to resolve this problem?
Question by:arthrex
    LVL 51

    Expert Comment


    Accepted Solution


    thanks for your response.
    I found the solution myself. I had to release the reference in the create statement of the view.
    Then it works

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now