Bob,

Were there any varchar fields in this table?

MSDN gives the following for the message:
ANSI_PADDING 'off'
SET ANSI_PADDING
Controls the way the column stores values shorter than the defined size of
the column, and the way the column stores values that have trailing blanks
in char, varchar, binary, and varbinary data.

Syntax
SET ANSI_PADDING { ON | OFF }

Remarks
Columns defined with char, varchar, binary, and varbinary data types have a
defined size.

This setting affects only the definition of new columns. After the column
is created, Microsoft® SQL Server™ stores the values based on the setting
when the column was created. Existing columns are not affected by a later
change to this setting.

Warning  It is recommended that ANSI_PADDING always be set to ON.

see http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/tsqlref/ts_set-set_2uw7.asp for more details.


Cathlene Mc Rae
HP Sr Response Engineer.

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *