Hello everybody,

I'm creating a DotnetNuke module with C# and VS2005. I'm using SQL Server 2000. I've created some tables with no errors. But if I try to modify a table adding a "ModuleID" column, of type integer,  I've got this error:

Cannot insert the value NULL into column 'ModuleID'....  column does not allow nulls. INSERT fails.

Why I've got this error? And why I've the error only if I try to modify an existing table, and not if I'm creating a new table?

Thanks.

I've solved the problem. Thank you very much leupold.