<div>
thanks pssandhu --<br />
I'll give that a try. &nbsp;I might just do the &quot;fix&quot;, rather than see which fields have the problem. &nbsp;As I look closer, I am finding more tables with this problem. &nbsp;I wonder if there an easy way to switch all my fields on all my tables to ANSI_PADDING = off.<br />
It sounds like I need to upgrade my programs -- according to &nbsp;Microsoft, ANSI_PADDING is going away in some future release of SQL Server.
</div>


thanks pssandhu --
I'll give that a try.  I might just do the "fix", rather than see which fields have the problem.  As I look closer, I am finding more tables with this problem.  I wonder if there an easy way to switch all my fields on all my tables to ANSI_PADDING = off.
It sounds like I need to upgrade my programs -- according to  Microsoft, ANSI_PADDING is going away in some future release of SQL Server.

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


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?

-- thanks

how do I find which columns have ANSI PADDING set to ON ?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.