how do I find which columns have ANSI PADDING set to ON ?
Posted on 2009-05-28
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?