I presume the only way is to Drop and Recreate the table with ANSI_NULLS on and import the data back. There goes my Weekend.

Thanks anyway..

If you can put the "insert to log before insert to table" out of the transaction then begin transaction

insert into table

insert into log

commit transaction.

I am pretty much sure since the error message clearly indicates the table name. The whole database was migrated from 6.5 and the tables i am joining is having huge...

quote:

---

Yeh pat yourself on the back, sycophants united. No one likes a smart a$$

Besides, the higher your pedestal...