An excellent article has been posted on DNJ Online , examining the use of XML in the forthcoming SQL Server 2005 (also known as 'Yukon'). Mark Whitehorn looks at the implications of supporting XML in a relational database.
A must read article for all the software developers.