Why do I get the SQL Server error "Msg 8412 - Schemas differ" when doing a LOAD TABLE?

A. If both tables have been defined identically the most common reason for this is when the exact error is "Msg 8412, Level 16, State 3" - with the state of 3 being the give-away. This problem occurs if both of the following conditions are true:

• The table has a nullable char or varchar column and was created under one ANSI_PADDING setting.
• The table was dumped, dropped, and re-created from a script, but with a different ANSI_PADDING option set.

This is usually caused by the tool being used to re-create the table setting a different default for the ANSI_PADDING value. See Q170639 for more info.