SQL Server Performance Forum – Threads Archive
Cannot insert the value NULL into columnAfter shifting of data from one server to another I recived following error"DB Provider for SQL Server error ‘80040e2f’ Cannot insert the value NULL into column ‘categories_id’, table ‘kuito.u8topi.categories’; column does not allow nulls. INSERT fails. /admin/add-category1.asp, line 22" .Pls suggest what to do
How did you shift the data? Make sure categories_id field of source table is not null EDIT :It seems that you are shifting the data by using ASP Page. If so, make sure the table has same structure in both the servers and also update service pack for those servers Madhivanan Failing to plan is Planning to fail
Even i feel the table schema is different on both servers.
On one the column accepts null values whereas the other one doesn’t.
So check properly the table columns and datatypes and their properties.
True and to findout generate the SQL script between the source and target.
Or else for the purpose of data transfer disable any such constraint on the target table. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.