This looks a good read to clarify the options around using XML with SQL Server 2005. I like the comparion table at the end - enjoy.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5xmloptions.asp