Can the DDL that the Vault install tool generates be fixed to work in SQL 2005?
There are a couple of syntax changes that affect the 2.0 scripts that cause them to fail on 2005. The syntax changes really are just "more strict" than SQL 2000 but do not do anything that'd fail on 2000. Things like fully qualifying fields/tables. The 2005 SQL would work on 2000 but not vice-versa.
Thanks
Feature Request: SQL Server 2005 support
Moderator: SourceGear