Toad World® Forums

TDM 3.4.2.6 - no scheme for DEFAULT object for MSSQL


#1

Hi,
I found a problem with Defaults in MSSQL 2008 model.

  1. Default name in Defaults list in TDM doesn’t contain scheme
  2. 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

cutty

Generated.SQL (1015 Bytes)

MSSQL_defaults.txp (24.1 KB)


#2

Hello Cutty,

Thanks for your bug notification. We will fix it for next version. CR # 62 470.

Thanks a lot!

Regards,

Vladka + TDM Team