Home Forums SQL Server 2005 SQL Server 2005 General Discussion Insert Error: Column name or number of supplied values does not match table definition. RE: Insert Error: Column name or number of supplied values does not match table definition.

  • March 1, 2010 at 5:53 pm

    #1126791

    I have been unable to make the insert succeed on SQL2k5 with any combination of changes in database settings. I have also failed to find reference to this in SQL2k anywhere online. I am going to have to agree with the other poster that you need to either specify the column list in the insert or the select statement or both. The best thought I have is to use the SQL Upgrade Adviser which should identify all of the offending procedures you will need to fix. Sorry about the bad news :crying:

    Toby