in TDM I have set a default value for attribute default constraint names so that they meet SQL Server’s naming convetion (if you create the default values in SQL Server Management Studio). The default value is defined as follows:
When running a model update the wizard is showing a change for each attribute not having already a default constraint (see attached image).
If I accept the changes I will have many duplicate names in my model because the attribute name is missing. Plus I will have to adjust the default constraint name e.g. if I add a default value later.
Another question is whether the generated SQL scripts will have code for these columns (they don’t have a default constraint)?
Also I have noted that I have to restart TDM to make my changes have an effect, e.g. in my first try I have used <%FullTableName%> by accident. After fixing this TDM still was using <%FullTableName%> instead of <%TableName%>.
Thank you for your help and best regards,