Hi. I have an MSSQL 2000 table, and whenever I try to make a structure change, I get the warning:
Warning: Columns have different ANSI_PADDING settings. New columns will be created with ANSI_PADDING 'on'.
I have ANSI_PADDING set to OFF on the entire database. I only have the problem with this one table. I assume that somehow a column has its ANSI_PADDING set to OFF (if that is even possible to set at the column-level).
How do I see which column has it set to ON, and then how would I change it?