i would definitely not go ahead with that and i cant find where to set it to leave ANSI NULL like it is?
any way this could be done?
anyway - my main problem is nut with ANSI NULL setting - i just want to change number of decimal places from 2 to 3 in one of the columns,
Why do you want to retain the ANSI_NULLS OFF setting? Do you have a check constraint that relies on that setting? ANSI_NULLS OFF has been deprecated for some time. In my experience, ANSI_NULLS OFF is most often set by accident than
You can use ALTER TABLE instead of the GUI if you want to change the column and retain the setting without recreating the table. For example:
ALTER TABLE dbo.MyTable
ALTER COLUMN MyCurrencyColumn decimal(18, 4) NOT NULL;
Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/