we had some problems with our database and now it seams to be corrected except we can not create new items on Headquarter. The error message recieved is the following:
run-time error '-2147217873(80040e2f)':
Cannot insert the value NULL into column 'DateCreated', table'uc_hq.dbo.Item'; column does not allow nulls. INSERT fails.
Can anyone help? Debby
for a reason or another, someone removed the default value for Item.DateCreated from your item table, all what u have to do is to execute the following statement
********************* ALTER TABLE Item ADD CONSTRAINT DF_Item_DateCreated DEFAULT getdate() FOR DateCreated ********************* NashatHave something to add? Share your thoughts — no account required.
Ask the community — no account required