I have a table
TempTable with one column having a default constraint
ALTER TABLE [dbo].[TempTable] ADD CONSTRAINT [DF_TempTable_Version] DEFAULT ((1)) FOR [Version]
Version is defined as
Most of the time the value 1.00 is inserted into the column but in some cases its inserting a null value.
How we can identify if the constraint is failing or if there is some other issues causing this?