September, 2005

Posts

| |

|

Jeff Papiez - SQL Server Test Developer

SQL Server 2005 Upgrade Advisor and SQL Clusters

Posted over 7 years ago

by jpapiez
- 3 Comments
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...
Jeff Papiez - SQL Server Test Developer

Passing a DataSet to a SQLCLR Stored Procedure

Posted over 7 years ago

by jpapiez
- 3 Comments
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...