I have Visual Studio .Net 2003...I am assuming that since it can't find
System.Data.SQLServer that I need Visual Studio 2005 to develop CLR apps for
SQL?

Hello RSH,

Correct

Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/

There's no System.Data.SQLServer anymore. You use the regular connection objects, reader etc. For
SQLCLR specific things (like context and pipe), you use the Microsoft.SqlServer.Server namespace.
You do need Framework 2.0 (as the things you need are in the System.Data.dll file that comes with
Framework 2.0). You can download Framework 2.0 and write your CLR objects using Notepad and
command-line compile them. If you want to use VS to write SQLCLR objects you need VS 2005.

Show quoteHide quote

You don't really need Visual Studio at all.  You can download the .NET 2.0
SDK and use the command-line tools.  But if you want the IDE experience,
yes, VS2005 is necessary.


Show quoteHide quote

Newbie: Timeout On IN statement
Getting an unused number from a set of numbers?
Design: multiple columns for primary key
Whats Wrong with the Query?
TSQL Debugger Oddity