Any magic to convert from one to another? I want to pass a DataTable as a
resultset and thought I could pass the "DataReader" that's exported by
CreateDataReader on the 2.0 DataTable class.

I executed the following code:
               ' Return the contents of the WordCounts collection to SQL
Server as a rowset
               ' Define the row to be sent to SQL Server

Ah, how does one set the RETURN value in a CLR SP or is this not supported?
The compiler does not like the AS SQLINT32 code...

I have problem in the method name that I have written to be used as
"FillRowMethodName":
Imagine I want to use FileSystem.Drives to prepare three columns in
resultset: DriveLetter, TotalSpace and FreeSpace. I'm trying to access each

I have successfully installed MS SQL Server 2005 Express. I can open the
databases in SQL Server Management Studio.
But when I try to set up a DSN in the ODBC administrator, I get this error
message (my translation):

The doc says that this function is called when "converting" but not when new
rows are added or changed. Ah, since it's not called on CONVERT, when IS it
called? Can someone clarify this?

OK to get straight to the point, is it possible to use CLR stored procs from
SQLExpress instance or from an MDF external database file ?
If the answer is "no and no" then there's no need to read on, otherwise
please read on.....

   I've an EndPoint that works fine in a server with a default instance.
The problem appear when I put to work the same EndPoint in a server with a
named instance. The definition code of my EndPoint is that:
CREATE ENDPOINT sqlendpoint

I have the following query:
SELECT
   C.CompanyName,
   O.OrderDate,

I have large ammounts of data(>50.000 records) which I wan't to store an
array. Is it possible to store such an array in memory inside SQL-server,
and to use this array from different stored procedures(CLR) ? (Public,
Shared)

I am trying to use SqlDependency to keep track of any changes on the data.
The program works fine when change in the data occurs for the first time,
but the event is not captured if more changes are made.
Thanks

Why does a UDA with Format.UserDefined need implementation of Write and Read
methods? UDA does not write anything on disk.
Thanks in advance,
Leila

How can I create index on X property of my Point UDT?
Thanks in advance,
Leila

In SQL-DMO , under the object IntegratedSecurity, the ImpersonateClient
property exposes the security context for nonadministrative users executing
xp_cmdshell.
I am facing problems in accesing this property using DMO on Yukon (as its

I wanted to create an index on a property of my UDT and used this DDL:
create table t2(
c1 int identity,
c2 point,