I created a UDA for concatenate string with ,. I need the return string to be
in order. I found the IsInvariantToOrder param but the documantation says
"Reserved for future use". Is this is the property that will sort my data?
when will it be used and what can I do untill then?

I am using OPENQUERY in a CLR (for quering OLAP) and noticed that any
string/sqlstring parameter assigned is limited to 4000 chars. As
nvarchar(max) can hold more than 4000 chars, the CLR parametertypes should
handle also more than 4000 chars. Are there any work arounds besides ...

Can we write a CLR user-defined function using Visual C++ with the "/clr" or
"/clr:pure" compiler switch? Our aim is to use a readily available native
C++ code in the UDF to work with a byte array passed to the UDF. We are
using Visual Studio 2005 and SQL Server 2005.

We have an applicaton that requires that access to a remote Web Service is
obtained and info retrieved during execution of a stored procedure.  Our
first thought was to utilize a CLR stored procedure that would access the web
service. Using C# seemed like a fairly simple method ...

Hi NG
I need to generate Reports using ReportViewer and email them to recipients.
Our client uses a hosted environment that does not have access to Reporting
services.  We would like to create a CLR function that produces the

i have a web service i get data from using clr. code is working fine. what i
can't figure out is how do i poiint this clr from lets say dev webserver to
production. the best way i could come up with is to remove/add references
each time i deploy procedure. i am a dba not a ...