http://www.YukonXML.com YukonXML.com (also known as SS2005.com) is a SQL Server community, containing great articles, up-to-date news, discussions, books sample chapters, resources, and media. en-us Copyright 2000-2005 YukonXML.com 7/4/2008 10:41:50 AM http://www.YukonXML.com YukonXML.com Feed Generator 1.0 editor@YukonXML.com editor@YukonXML.com 60 http://www.YukonXML.com/images/yxLogo.gif http://www.YukonXML.com http://www.YukonXML.com/articles/sqlclrBy now you might have heard that SQL Server 2005 hosts the .NET 2.0 runtime. This enables writing stored procedures, functions and triggers using any of the managed languages, such as C# and VB .NET. This article is based on my first experience with SQLCLR integration, where I converted some of the documented and un-documented extended stored procedures to managed procedures and functions.Thursday, December 09, 2004http://www.YukonXML.com/articles/sqlclrhttp://www.YukonXML.com/articles/smoMicrosoft SQL Server 2000 supports a COM-based object model, called SQL-DMO, which can be used to programmatically manage the SQL Servers. SQL Server 2005 replaces SQL-DMO with two .NET based object libraries: SQL Server Management Objects (SMO) & Replication Management Objects (RMO). In this short tutorial, I'll show you how you can use SMO in your .NET applications.Thursday, July 29, 2004http://www.YukonXML.com/articles/smohttp://www.YukonXML.com/articles/xquery/XQuery or XML Query Language is a W3C specification designed to provide a flexible and standardized way of searching through (semi-structured) data that is either physically stored as XML or virtualized as XML (such as XML Views over relational data). To give you an analogy, SQL is used to query relational data, XQuery is a standard language for querying XML data. This article is an introduction to XQuery language (based on November 2003 working draft).Monday, February 02, 2004http://www.YukonXML.com/articles/xquery/http://www.YukonXML.com/articles/sql2000xml/Microsoft® SQL Server™ 2000 first introduced native support for XML and HTTP. Since then, to keep up with XML, Web services and .NET advancements, Microsoft has made available add-ons to SQL Server 2000 in the form of SQLXML Web releases. This article begins with explaining the built-in XML and HTTP support in SQL Server 2000 and then it describes the features available in the recent SQLXML Web release (version 3.0, service pack 2).Monday, January 26, 2004http://www.YukonXML.com/articles/sql2000xml/