Insert Error: Column name or number of supplied values does not match table definition.

Hi,
Can someone help me on this error, which says
Insert Error: Column name or number of supplied values does not match table definition.
The stored procedure has been inserting values since years but now it thows error .Please help how to debug.
Regards
Tanu

- has anything changed like new metadata release.
- Check if the table which the stored procdeure is referencing. If you can post the code and table desc it would be helpful for forum members to assist.
-sat

Hi,
some colum might be added or removed in you table schema.
check the columns in sp and schema it will work.

Number of column specified in insert list do not match number of columns in values list.
Ex. INSERT <table> (A,B,C) VALUES ('A','B') or INSERT <table> (A,B) VALUES ('A','B','C')
This is very common error when we don't specify the column list in INSERT statements.

no the table is used since last few years and there has been no change in the table defination ...
the code is something like
Insert into <table> EXEC sp_search
which worked fine till four days back
Re
Tanu

Can you execute the procedure sp_search seperately, and see the number of columns?

Yes . I can and even the number of columns are same as in the insert table