The current recommendation is to write TSQL stored procedures for intensive data-manipulation functionality and managed code for functionality that is calculation-intensive.
My guess is that we'll see the use of managed code be abused in the beginning strictly because of the "neat technology" aspect of it.
There's a lot of good SQL Server 2005 information at
http://www.microsoft.com/sql/yukon/productinfo/-Mike
>My understanding is that some things will still be better coded in T-SQL and others in .NET, but I haven't done any experimenting with Yukon, so others may chime in and clarify this.
>
>>I've been wondering about this using C# to write store procedure thing. From my understanding, it is just using a different syntax to write the same store procedure. Since most of the code in a store proc are SELECT/INSERT/UPDATE statements, I really don't see that much different. Are there other enhancements that I don't know about?