Unable to modify table. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column

Published by: Guest (9/27/2008 11:34:38 AM)

I added a new column to the existing table and set it to not null but i am getting error and not able to get my desired result. Any one knows why i get this error? ’table_name’ table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column ’column_name’, table ’database.dbo.Tmp_table_name’; column does not allow nulls. INSERT fails.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

 

Most Popular Articles

• SQL Server 2008 Error: is not a valid login or you do not have permission
• Cannot start .aspx
• what is the difference between Text and String Data type in SQL Server
• Error: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
• Why my MS SQL Server 2005 DSN Connection is not Working

What to do When I Accidentally Deleted my MSSQL Server 2005 Database >>

<< Unable to Create Index for a Table in SQL Server Management Studio 2005