Yukon CLR Stored Procedures
I haven't really had the time to mess with Yukon as of yet but I came up with an interesting question regarding how the CLR stored procedures actually work. I was in the middle of a project and was in Enterprise Manager ( sql2000 ) writing a stored procedure and it hit me, what happens in the new architecture when an error is thrown in the CLR for a Stored Proc? Is it designed as one complete process where the CLR and T-sql co-exist or are they seperate layers? If an error is thrown in the common language runtime does it ever even get to the t-sql layer? If they are not one process does that mean it runs slower? I asked Kent Tegels this question and his answer made sense but he was not completely certain so this will take some investigation and reading on my part.