Thanks Kevin

the XEN product sounds great. I need to learn more about t-sql

I will put more time into .net 2005 / MM when my projected move to SQL is completed.

jp

>John,
>
>>Question #1 Since the clr is now part of SQLServer is there any plan to add a VFP like assembly to SQLServer my thought is there is probably a need for a Yukon assembly that provides a base functionality for traversing a "VIEW" / Cursor record by record not SET/SET a couple of functions, commands should do it
>
>
>>Question #2 Is there any plans to provide a Yukon clr based assembly (a rank newbee here so this question might not make any sense) kind of a way to send commands/programs to Yukon on the fly and get back info that a straight SQL statement can't do ??? kind of like codeblock / MM
>
>In this upcoming version of SQL Server you will be able to write stored procedures in either C# or VB .NET...Microsoft knows that many developers DON'T write stored procedures (even when they should for performance reasons) because it's one other learning curve to climb (T-SQL). Other than what's been mentioned with Xen (data manipulation built right into the C# language...which will NOT ship any time in the near future) data access in .NET will continue to be collection-based...a DataSet will a collection of Tables, and Tables with collections of rows that you can scan through using foreach. That said, I think a lot of what you're looking to do can be accomplished right now by means of standard T-SQL.
>
>Regards,