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.


Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish