We have problem with a specific row when saved and even noticed this type of error
Msg 213, Level 16, State 1, Line 29
Column name or number of supplied values does not match table definition.
After checking what was happening we noticed a user decided to use "/" and iserted ion the transaction code. So when the transacion is saved via the apps, we get the error above:
The error occur when:
INSERT INTO tablename VALUES ('TRAN/1002',0,0,0)
How can we save to our ms sql tables even though a user decided to use "/"?