Hi,

you may use extended properties.
you define it and set its value either in SSMS (right click on the database node, properties, extended properties), or by script with the sp_addextendedproperties sytem SP:

EXEC [BSA1].sys.sp_addextendedproperty @name=N'DDT_PropertiesDeployed', @value=N'True'

the sys.updateextendedproperties is for updating, and you read it with the fn_listextendedproperty system function:

SELECT objtype, objname, name, value
FROM fn_listextendedproperty(default, default, default, default, default, default, default);