Re: "Do Not Allow Null" fields suddenly accept Nulls

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 02/23/05 

Date: Wed, 23 Feb 2005 07:50:56 -0800

Hi Scarfie

What does "delete a record from the field" mean. Delete only applies to
whole rows, and whole rows can always be deleted no matter what Nullability
setting you have.
Do you mean you're changing the value of the field to something else?

How are you making that change? I suggest you NOT use Enterprise Manager for
this, as it is not intended to be a data management tool. You may be
changing the value to blank, which is not the same as a null.

Try in Query Analyzer:

update my_table -- whatever the name of your table is
set my_column = NULL -- use one of the columns you think doesn't allow
nulls
where <supply a meaningful condition for this table>

Let us know what happens. If you get an error, show us. If not, show us the
DDL for the table:

exec sp_help my_table

Also, what version are you using? 

-- 
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Scarfie" <Scarfie@discussions.microsoft.com> wrote in message 
news:31F93F06-BEEC-456C-8568-B07E8A257133@microsoft.com...
>A problem that has just reared up in the past week... all fields that are 
>set
> to "Not Null" are now allowing nulls.  We can delete a record from the 
> field
> and the database saves it just fine.  Normally it would prompt an error
> message saying the field does not accept null data.
>
> This just started happening and it is happening across all of the 
> databases
> on the server.  I've checked several references on what may be causing 
> this
> but have come up with nothing.
>
> Strange...and not very usefull for data integrity.  Can someone shed some
> light?

Relevant Pages

  • Re: What does this NULL mean?
    ... > always will be NULLS in the real world." ... > comp.databases.theory thread "Does Codd's view of a relational database ... > presenting lots of possible reasons was a very bad argument because only ... management of systems with evolving schema, ...
    (comp.databases.theory)
  • Re: Newie Question (or am I nuts)
    ... It is a fundamental part of the Relational Model which Dr. E. F. ... database really relational?". ... > The problem is that c and c++ don't have the concept of nulls. ... > nulls in VB (or, in our case the VBA, but for all intensive purposes VB ...
    (microsoft.public.access.formscoding)
  • Re: What does this NULL mean?
    ... out of existence have no demonstrated understanding of the database change management environment, and specifically the management of schema evolution and its consequences in regard to the generation of nulls. ... An exception would be when he starts out by defining a Relation the way he does in his Intro to Database Systems, ... eliminating SQL from the ... ever materialises would lead to an exponential number of relvars with ...
    (comp.databases.theory)
  • Re: TIP#308: Choice of dict as the row representation
    ... names with the possibility of NULLs. ... place the onus on the database driver to disambiguate the names, ... you can specifically tell the database to insert whatever substitute ...
    (comp.lang.tcl)
  • Re: Database recovery with data file only
    ... Basically using that command breaks your business logic as there's no ... "Dan Guzman" wrote in message ... >> database Backup as well as ... >>> SQL Server MVP ...
    (microsoft.public.sqlserver.server)
Loading