What are the challenges you face when working across database platforms? Take the survey

Set option error

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited September 25, 2003 10:32AM in SQL Compare Previous Versions
Hi Eric,

Thanks for the post. I think that the key to solving the problem is to
find the constratin to the table 'NTRATE' that is causing the script to
bomb. Obvoiusly, there is an ALTER TABLE ADD CONSTRAINT statement in the
script that can't be run for some reason or other.


Brian Donahue
Red Gate Technical Support

"lakusha@excite.com" <Lakusha@excite.com> wrote in message
> Hello,
> I have the following error with a sync script (SQL Compare 2.03):
> The object was renamed to 'NTRATE'.
> Server: Msg 1934, Level 16, State 1, Line 4
> ALTER TABLE failed because the following SET options have incorrect
> Server: Msg 1750, Level 16, State 1, Line 4
> Could not create constraint. See previous errors.
> I've looked at the script generated by SQLCompare and I can't see the
> problem. The error comes from:
> --> set
> Anybody have an idea?
> ps: SQL2000 SP3a Enterprise on a 4 way server. Medium large script
> regards,
> Eric
This discussion has been closed.