ANSI_PADDING

Mar 10, 2008

Is there a way to set the default of ANSI_PADDING to OFF instead of ON?

View 2 Replies

How To Update ANSI_PADDING To ON

Oct 11, 2006

Hi

how can I update ANSI_PADDING to ON for a table using script without dropping the table.

Please help.

View 6 Replies View Related

SQL Server Overrides My ANSI_PADDING Setting

Jul 20, 2005

I used Enterprise Manager to change the data type of one table columnfrom one thing to another. When I attempted to save the change, I waswarned that "one or more existing columns have ANSI_PADDING 'off' andwill be re-created with ANSI_PADDING 'on'". I didn't expect to seethis message. I verified that ANSI_PADDING is 'off' at the databaselevel by running the following statement:SELECT DATABASEPROPERTYEX('database', 'IsAnsiPaddingEnabled')Further, the ANSI padding option on the Connections tab of the SQLServer Properties window is not selected. If ANSI_PADDING is 'off' atthe database level, why does SQL Server assume I want to re-create acolumn with ANSI_PADDING 'on'?

View 1 Replies View Related