Hello,
I have two server both running SQL 7 SP4 on W2K server SP 4. One SQL server is both the distributor and publishwer and the other one is the subscriber. I published one database on the server (replication type = shapshot) and there were no problems when ru
nning the jobs that this task creates. But when running the pull job on the subscriber, I get the following error:
Could not drop object 'ACCION' because it is referenced by a FOREIGN KEY constraint.
I don't know why this job attemps to drop the table ACCION when all it's supposed to do is to refresh the data. Or is the way it works?
Any help
Regards
Hi,
I was trying to replicate the error that you are facing.
I was able to replicate the error.
What I understand is, if you modify the relationship at the publisher and
after that when the agent tries to apply the changes to the subscriber, it
throws this error.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
Friday, February 17, 2012
Error Shapshot Pull (Subscriber)
Labels:
database,
distributor,
error,
microsoft,
mysql,
oracle,
publishwer,
pull,
running,
server,
shapshot,
sp4,
sql,
subscriber,
w2k
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment