I just created a second CLR function and inspected the Output Debug window.
I noticed that a host of DLLs were loaded even though my function only
returns a string "hello". More troubling, however was the fact that symbols
were loaded for the first project (a temperature ...

I've tried a couple of tools and there doesn't seem to be any way to attach
to the SQL Server process... I'm assuming there's some way to do this, since
we can debug?

I want to use a trigger on a view.
I have 2 tables (t1 and t2) and a view (v1) which looks to the table t1.
Definitions
CREATE TABLE [t1] (

I was trying to get a CallStack (i.e. list of methods called on a type)
while debugging a sql script with CLR type.  I want to see all the methods
that were called on the type before the break point in the script.  I could
not figure out how to do that.  Any ideas?

About two month ago, I read a discussion here and one of the gurus had
suggested to write a shared method in UDT that instantiates an empty UDT to
return it for caller:
Public Shared Function GetNewPoint() As Point

Why would they not support [NonSerialized] on a UDT?

I want Parse method in my UDT (point) return a point like "0:0" if the user
passed NULL into INSERT statement. Here is my Parse methods:
-----------
Public Shared Function Parse(ByVal s As SqlString) As Point

I'm examining the Point UDT with the definition in MSDN:
ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.SQL.v2005.en/denet9/html/1e5b43b3-4971-45ee-a591-3f535e2ac722.htm
When I try this batch, I get NULL as expected:
declare @a point

I want to use UserDefined format for my CLR UDT and I need a formula to
calculate its MaxSize.
Thanks in advance,
Leila

According to my previous posts about controlling NULL value in Parse method,
I have another question:
When I perform a SELECT * (without using ToString() method) I get this
error:

In the first line of description for SqlMethodAttribute Members in MSDN has
been stated that:
"Indicates the determinism and data access properties of a method or
property on a user-defined type (UDT)".

I am trying to use Point UDT from MSDN. But when I insert a null into this
column, my SELECT on the table generates an error:
An error occurred while executing batch. Error message is: Data is Null.
This method or property cannot be called on Null values.

MSDN describes that Name property of
Microsoft.SqlServer.Server.SqlUserDefinedType is not used by SQL Server, but
by VS.NET IDE. I have set a name for my UDT, how can I see its effect it
VS.NET IDE?

How are you able to check if a context connection already has been opened ??
ConnectionState on the connection will always return "Closed"
Say you got a function in the CLR that you want to call from both inside and
outside (through TSQL wrappers) the CLR. When calling the function ...

1) Can you determine if your UDT is actually executing inside SQL (hence not
on a client)?
2)  Is there a faster way to get something like "@@language" then having to
query for it in connection context?  TIA