If you've thought about using SQL Server 2005 Upgrade Advisor to determine the upgradability of your SQL Server 2000 cluster, be aware of the following issue. When you launch the Upgrade Advisor Analysis Wizard, you're prompted for the Server Name, which
Read More...
Is it possible to pass a DataSet to SQL and process the data in a SQLCLR stored procedure? This is the question I set out to answer. The .NET Framework 2.0 adds some features to the DataSet that make this scenario possible (WriteXml, ReadXml). I created
Read More...
