I have 2 User-Defined Table Types in my database. When SQL Packager builds a script, it includes this statement for the Primary Key in the script:
- Code: Select all
But that is not a valid option. Thus, when I run the package against a SQL server I get this error:
'fillfactor' is not a recognized CREATE TYPE option.
So I have to manually edit the script first, then use SQL Packager to build the exe. I don't want to set SQL Packager to ignore Fillfactor because I don't want Fillfactor ignored on my table indexes.
Is this a bug with SQL Packager or have I done something wrong?