Problem trying to modify a table

• William Hall Dillon-327038

  SSC Eights!

  Points: 990

  More actions

  November 10, 2006 at 10:59 am

  #115052

  Hi All:

  I'm trying to modify a table that has a column set to "allow nulls" to not allow nulls. When using the EM table designer to make the change, I get this error message:

  'Notes' table

  - Unable to modify table.

  Cannot insert the value NULL into column 'Notes',

  table 'Collect.dbo.Tmp_Notes';

  column does not allow nulls. INSERT fails.

  The statement has been terminated.

  Thanks for any help on this

  William

• chandrika5

  SSCrazy

  Points: 2734

  More actions

  November 10, 2006 at 11:11 am

  #671152

  I was in a similar sitituation. I first updated the column to a space and than alterted the table  to not allow nulls.

  Depending upon number of records and data type, you can do a simple update in query analyzer. Mine was char(50) and about 5000 records.

   

   

• faizjmc

  SSC Eights!

  Points: 881

  More actions

  November 14, 2006 at 4:32 am

  #671550

  The reason is that, a constraint can be applied only when there is no conflict with the existing data.

  So be sure that you handle that before