> Thank you Larry, the autonumbered column is not > included in the insert. The > insert does work as expected with the exception of > the error message.
Other things: 1. Are you sure that the list of columns that you specify has the same number of items as the list of values? 2. Make sure you do not include a computed column in the columns you are inserting. You shouldn't see that message unless there is some problem with the list of columns you are inserting. As a matter of good programming practice, your code should not produce any unexpected error messages. For expected error messages (like Table MyTable Does Not Exist when dropping a temp table before creating it), you can use SET ERROR MESSAGE 123 OFF and ON to suppress the error message. -- Larry
