I have designing in my web page .my database table the id is allow null value i have set ok.i had store the value in table.but i want Id values not allow null value .how to change in my table sql server2005 managementstudio ok..
but i have uncheck the coulm ok but error display
'tblMainPhotosettings' table - Unable to modify table. Cannot insert the value NULL into column 'Id', table 'Photostudio.dbo.Tmp_tblMainPhotosettings'; column does not allow nulls. INSERT fails. The statement has been terminated.