Thanks for the suggestions. I have considered them all but still have not found a reliable solution yet. Still working on it though. I have tried changign the data types...

This a big problem for me. After working on an application for about a year, it is suddenly crashing all around me due to this issue. MS offers no solution...

The online books say that you can turn it off using the ALTER DATABASE command

ALTER DATABASE "Northwind"

SET ANSI_PADDING OFF

GO

This does change the property value but the behavior does not...