This seems to be a database specific issue.
Try looking at/editing the conf/standardjbosscmp-jdbc.xml file. You can either change the alter table template (also see details in the wiki), or you can change the default typemappings for your database to include default values for some types (probably numeric types).
There was nothing about "add column" in the MS SQL section so I tried to add
<add-column-template>ALTER TABLE ?1 ADD COLUMN ?2 ?3</add-column-template>
but I got an error saying:
Invalid XML: file=file:/.../standardjbosscmp-jdbc.xml
The order of the items is important.
If nothing was in the file, then the default template is used, so just adding this template will not be enough as it still doesn't set any of the constraints on the fields.
Unfortunately my knowledge of MS SQL is insufficient to give specific help.
However, I constantly use this for feature for the Firebird database, and have changed the default type mappings to include default values to prevent similar issues. You may have a look there.
Once you have got working changes, please submit the modifications as a bug report.