I looked at the ADO execution through SQL Profiler. All the columns are populated. Those not assigned were NULL as expected. The sp_executesql stored procedure ran, but...

Steve,

Thanks for your response. Yes, the DataSet being updated in ADO.Net includes the default columns. There's no easy way around that because under some conditions those columns need...

Carl,

Thanks for your response. The INSERT INTO works, as you say because I have not included the defaulted columns. It is the ADO.Net SqlAdapter.Update that fails to fire...