I have just started setting up a BizTalk 2009 machine to start looking at the CTP and something I noticed in theinstallation guide kind of supported what I was saying the other day about BAM being misplaced. We knew that SSNS was not part of SQL 2008, and as BizTalk documentation is saying use the old SQL 2005 component if you want BAM Alerts (see below). I believe the roadmap for the features which SSNS provided are intended to eventually end up in SQL Reporting Services so this would seem to support that the future of BAM belongs in the SQL Server BI offering
“To install SQL Notification Services
- If your BizTalk Server 2009 project uses BAM Alerts, you must install SQL Notification Services and its prerequisites on your BizTalk Server computer. This SQL Server 2005 feature is not included in SQL Server 2008, but you can install it from http://go.microsoft.com/fwlink/?LinkId=131668.”
(courtesy of BizTalk 2009 CTP documentation)