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?
arthrexAsked:
Who is Participating?
 
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
 
Ted BouskillSenior Software DeveloperCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.