Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1061
  • Last Modified:

SQL Replication Problem - References between Views and Tables

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?
0
arthrex
Asked:
arthrex
1 Solution
 
Ted BouskillSenior Software DeveloperCommented:
0
 
arthrexAuthor Commented:
Hi,

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
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now