BizTalk EDIDB Database created with SQL Compatibility Level 70 in SQL Server 2005

When configuring the Base EDI Adapter component of BizTalk Server 2006 against a SQL Server 2005 Database, you would notice that the EDIDB database is created with compatibility level 70. One or more SQL Scripts written to manage SQL Server 2005 databases may fail if any of the commands specific to Compatibility Levels 80 or 90 are used.

So if you are wondering why this database has been created in this way, it's because the Base EDI Adapter created by Covast requires compatibility level 7.0. This must not be changed. Instead, the scripts would have to be modified to take into consideration that the EDIDB is at compatibility level 70.

(For information on how to check/set the Compatibility Level of a SQL Server database refer to sp_dbcmptlevel documentation)