Im trying to get dataset (table etc) from clr function/procedure. I know
there is VTF functions that allow return table of values. But this requires
specify columns that function returns.
There is also SqlContext.Pipe.Send - so I can pass sqlReader and get table

I am currently trying to write a very simple UDT that checks for the
existence of a file. If the file does not exist it should return null.
It doesn't seem to see the file even when it exists, however. I've
checked and rechecked and the file is there. HELP!

Quick question - I have a SQLCLR UDF that uses the .NET FileInfo object to
get information about a file that I pass in.  For local drives (C:, D:,
etc.) it works fine.  If I use a mapped network drive, I get an error
message though.  Strange thing is if I use the full UNC path it ...

Can I use VS2008 to create C# User Defined Functions etc for SQL
Server 2005?
1)  Would installing the .Net 3.5 framework on the SQL Server 2005
server do this?