Set option error

Brian DonahueBrian Donahue Posts: 6,590 New member
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.

Regards,

Brian Donahue
Red Gate Technical Support

"[email protected]" <[email protected]> wrote in message
news:[email protected]
> 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
> settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
> 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
>
ANSI_PADDING,ANSI_WARNINGS,CONCAT_NULL_YIELDS_NULL,ARITHABORT,QUOTED_IDENTIF
> IER,ANSI_NULLS on
>
> Anybody have an idea?
>
> ps: SQL2000 SP3a Enterprise on a 4 way server. Medium large script
(2.7Mb).
>
> regards,
>
> Eric
>
>
This discussion has been closed.