SQL Server

[sujatha2405]

C# application is connected to SQL Server 2000.
SQL Server 2000 table allows 'INSERT' and 'UPDATE' commands work successfully with NULL values for all the NOT-NULL fields. No NONULLEXCEPTION is thrown. Please explain.

[debasisdas]

That is not possible .
There must be some error in your program or the command is not executing properly from C#.

[sujatha2405]

I checked my code many times. Only the primary key field validates the data for NULL and throws exception. The rest of the NOTNULL fields accepts all NULL values when INSERTed and UPDATEd from C#. But executing the same commands in the Query Analyser or data entry done directly works as expected i.e. throws errors when NULL values are inserted or updated. This is strange.

[debasisdas]

are you using any procedure or directly executing the sql statment ???