Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
Why do I get the SQL Server error "Msg 8412 - Schemas differ" when doing a LOAD TABLE?
Neil Pike
April 6, 1999
1 Min Read
A. If both tables have been defined identically the most commonreason for this is when the exact error is "Msg 8412, Level 16, State3" - with the state of 3 being the give-away. This problem occurs if bothof the following conditions are true:
The table has a nullable char or varchar column and was created under oneANSI_PADDING setting.
The table was dumped, dropped, and re-created from a script, but with adifferent ANSI_PADDING option set.
This is usually caused by the tool being used to re-create the table settinga different default for the ANSI_PADDING value. See Q170639 for more info.
About the Author
You May Also Like
.png?width=700&auto=webp&quality=80&disable=upscale)