Hi I was trying to copy 4,000 records from one table to another table , every thing was going fine but suddenly got this error <BR><BR>Error Type:<BR>Microsoft OLE DB Provider for SQL Server (0x80040E21)<BR>Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.<BR>/ok/master/updatedata.asp, line 36<BR><BR>and the line is refering to a company name field. it did copied apx 500 records though. what is this error about. any input will be appreciated about this error and atleast three ways to remove this error or to find out what is this error about please .