E' disponibile l'RC1 del "Component Package" per utilizzare Notification Services anche su SQL Server 2008:

http://www.microsoft.com/downloads/details.aspx?FamilyId=614FFDF3-C608-4BD3-9061-AE37DCC81E2B&displaylang=en