the statement :

declare @x xml

is not working for me in sql server 2005 too..Is there any configuration I need to do specifically to enable that.

Hi Jacob,

I was really excited after reading your article and started to try implementing the xml stuff on my sql server 2000 query analyzer.

I could select the table data as...