How is fastest way to construct an XML node then a bunch of slow xquery
modify statements?
This SQL Server 2005 logic is rather slow to simply add a new item to an xml
document. Any way to do this all in one statement and faster for creating a

When building a CLR UDT in Visual Studio, one of the issues is that VS insists on recompiling and deploying on each run. This means I have to drop all dependent objects (tables that use the UDT), deploy the "new" UDT, rebuild the table and repopulate it with test data.
I also ...

I set my database to trustworthy and deployed this clr stored proc as unsafe
ok but when i run this it returns 1 each time. as if ival keeps getting set
back to 0 each time i call this clr stored proc. How to fix so that ival
keeps its current value each time i execute this from ...

I heard there is some trick to referencing statics in C# CLR stored
procedure without having to mark the assembly as unsafe. Does anyone know
this? This is usefull as the case of needing a little static shared variable
here and there without having to compromise safety in the Sql ...

CLR Shared Memory, C# DLL load
How to share memory between CLR calls to the same C# dll? Is there some way
to know in the C# dll when the dll is loaded? Is the dll reloaded each tiem
a method is called from SQL Server or is the DLL loaded once when the C# dll

there seems to be some overhead between SQL Server 2005 and a CLR function
written in C#. Why is this?
I have a simple wraper around System.Diagnostics.Stopwatch.GetTimestamp() :
public partial class UserDefinedFunctions

what are the memory caps for threads running as a CLR stored procedure
executed by sql server 2005? is it limited by OS only or also by sql servers
memory limits? e.g. lets say my clr stored procedure is executed by sql
server 2005 then it creates 10 threads and each thread ...

Unable to start TSQL Debugging. Could not attach to SQL Server Process on
'srvname'. The RPC server is unavailable.
I get this error when I try to run a SQL Server Project with a CLR stored
Procedure in it. The target DB is SQL Server 2005 and im using VS 2005. I

easiest way to upload a C# class library to a SQL server 2005 and deploy as
CLR function
Do I have to upload the .dll and then run sql command to load it into sql
server, or is there a more integrated way to do this in visual studio 2005

How to create a CLR DLL for Sql Server 2005? Is it just any .net class
library that you can load into Sql Server 2005 or is there some special
project type that I need to start with?

what is the best way to store passwords and credit card information in SQL
Server 2005?

Hi,
I have encountered a somewhat strange problem with transactions.
In my SQL CLR code running on SQL 2005 Standard
I have created an explicit transaction

I need to call SQL function/stored proc from a CLR User-Defined Data Type
code.
How can I do it?
Evan

Hi. Crossposted to microsoft.public.inetserver.iis.security because
the issue seems bizzare and I have no idea
where the problem lies.
We have a CLR that calls ASP.NET Web Service using NetworkCredentials