Sep 16, 2009 09:01 AM|giles.hinton|LINK
As I said
You also don't need SQL Server 2005 to do this - it's been supported at least since 2000, although it's done in a slightly different way.
Although I don't have a reference to hand I believe the procedure you call is something like sp_preparedocument or sp_preparexmldocument - you can load a fragment into this and then query it using xpath.
SQL Server 2005 supports the same thing and doesn't require use of xml params, although obviously by using those you get to check whether the XML being passed in is valid.