Using the SQLXML Managed Classes
Take a look at the bridges that SQLXML provides between SQL Server 2000 and the .NET Framework.
http://www.developer.com/xml/article.php/3341881