Thanks for the patches, but I'm afraid they are not yet good enough to incorporate in the jetspeed src.
I see a lot of changes on column data types (e.g. INT -> INTEGER) and adjustments for the changed table definitions, which seems fine to me.
But, what has gone missing (including possible required adjustments) is all the required mssql trigger code.
For mssql, as it doesn't properly support (standard) cascade deletes for hierarchical references, there were are several tables which has additional triggers to deal with that functionality (e.g. FOLDER, FOLDER_MENU, FRAGMENT, PAGE_MENU).
In your environment you might not be yet using database stored psml, but to be able to do so, these additional triggers are required to handle hierarchical references on delete.
And the same and even more so applies to the drop-schema.sql!
You might also might want to review the issues
JS2-812 and JS2-838 which specifically dealt with these problems and were the basis for the current (but now outdated) hand crafted mssql schema sql.