You can configure the [!INCLUDE adaptersqlshort] to receive periodic data-change messages for SQL Server tables or views by using SELECT statements or stored procedures that include a FOR XML clause.

Although SQL2008 XML is lots better than 2005, which is better than 2000, it still has a very, very long way to go.