...any "All Nulls" setting in SQL Server. Can you describe you you set it to Disabled??? <BR><BR>It's hard for me to conceive of why such a setting would exist. Are you sure you are reading the documentation correctly?<BR><BR><BR><BR>
Sorry It was typing mistake.I want to say that I check out the 'Allow Nulls' check box that resides every fields.Now can you tell me?In access if a field is required than database raise an error automatically why my SQL Server isn't?
...but it works fine for me. If I create a field and declare it as "NON NULL" then I *do* get an error if I attempt to set or leave it null. Is it possible that you are *also* setting a default value? If so, then the default value would be used whenever you omitted to supply one.