Cumulative update package 2 for BizTalk Server 2009 fails if a BizTalk group uses a database that uses a case-sensitive collation

Consider the following scenario:

• You configure a BizTalk group to use a database on a computer that is running Microsoft BizTalk Server 2009. The database uses a case-sensitive collation.
  
  For example, the database uses the Latin1_General_100_CS_AI collation.
• You try to apply cumulative update package 2 for BizTalk Server 2009.

In this scenario, the installation fails.

For more information about cumulative update package 2 for BizTalk Server 2009, click the following article number to view the article in the Microsoft Knowledge Base:

This issue occurs because of an error in the Bts_tracking_logic.sql file that is included in cumulative update package 2. 

The Bts_tracking_logic.sql file creates a temporary table that has the name of #Permission. However, the Bts_tracking_logic.sql file refers the table as #permission when the script tries to delete the table.

Cumulative update information

The hotfix that resolves this issue is included in cumulative update package 3 for BizTalk Server 2009.

For more information about how to obtain the cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

For more information about BizTalk Server hotfixes, click the following article number to view the article in the Microsoft Knowledge Base: