hi all,
My problem is: I have created a table using "ansi_nulls off". And now I want to create an indexed view on this table. I really don't want to re-create this table - this table contains too many triggers, foreign keys and other constraints. And also thousands data rows...

I found somehow this solution:
sp_configure 'allow updates', 1

reconfigure with override

update sysobjects set status = status | 0x20000000 where name = <tablename>

Could someone tell me, how dangerous is it, what could happen after this update??