Generate DDL - 'table: Database not defined' error

[andykennelly]

I've used Model Transformation to create a platform specific model from a platform independent model and I know want to generate DDL to run in a SQL environment to create tables etc. To do this I'm right-clicking on the package with my platform specific model elements (diagram and tables) and selecting/generate DDL. I fill out the presented 'Generate Package DDL' box correctly (or so I believe), click Generate and see a 'table:Database not defined' message.
I can't find any guidance on Sparx Help nor the Forum. Trawling the web I see I might need to specify a default database in Tools\Options\Source Code Engineering\Code editors..... which I do (SQL 2008), but I still get the same message when attempting to generate DDL.

Any clues, Sparxites?

[Dermot]

I assume the transformed tables are now set to SQL Server?
Check that the Generate Package to DDL | Use Databse field is set to blank.
Best place to check things is in the EAxample model - run a default generation on this Database example.

[Nizam Mohamed]

Andy you may need to check if the default database is set, before transforming.
(Settings->Database Datatypes and set SQL Server as default).

Nizam