I work at a Hosting Company in Brazil and we have been experiencing issues
with managed applications using .NET Framework 2.0 that connect to SQL
Server 2005 databases with a failover partner. These issues started
happening after we have applied KB928365

I need to write a stored procedure in C# for SQL Server 2005. This sp should
read and write to a file in the file system. I made a test by using Visual
Studio 2005 and I receive an exception:
System.Security.SecurityException: Request for the permission of type

How to make CLR stored procedure generate comments in TSQL when it is
deployed via visual studio?
e.g. when i right click the project and hit deploy, i want some comments to
appear in or around the SQL wrapper that calls the CLR function.

I am trying to create assembly, the assembly loads ok but then the next
message in the profiler is this line. I did not make any references to this
assembly. I tried adding it to the clr project and also copying from the
framework and placing into the folder but still get this ...

Is it possible to use typed datasets in a CLR sp?  If so, how would I go
about doing it.
There is no option from VS to create a DS while in a SQL project.  I tried
copying a DS from another project and got errors: Configuration manager and