Set option error

Brian Donahue

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

"lakusha@excite.com" <Lakusha@excite.com> wrote in message
news:Ahe8higgDHA.1228@server53...
> 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
>
>