I found a problem with Defaults in MSSQL 2008 model.
- Default name in Defaults list in TDM doesn’t contain scheme
- in a generated script
- DROP DEFAULT doesn’t contain scheme
- CREATE DEFAULT is OK
- Binding default to user type (call to sp_bindefault) doesn’t contain scheme for Default name
See attached files (generated script with suggested correction and MSSQL model with one Default and one User type)
Could you check the problem?
Thanks & regards
Generated.SQL (1015 Bytes)
MSSQL_defaults.txp (24.1 KB)