I have a CLR stored proc that makes a connection to an Access database using
oledb jet (or tries to).  I get the error below.  Anyone come across this
before? I'm assuming it's to do with permissions but not sure.  FYI - the
assembly's permission level is set as Unsafe.

I've created a CLR stored proc that consumes a web service.  the URL for the
service should depend on the active build configuration i.e. in [Debug] mode
it should use my development URL (e.g. http://dev/...) but in [Release] mode
it should use a production URL (e.g. http://prod/ ...

I have mapped a share (actually a share on the local computer that is running
SS2k5) and want to use a CLR stored procedure to gain access to it.
When I do this:
       sSearchPath = "C:\Q"

hi, I've written a CLR stored procedure and in the StoredProcedures class I
stored a:
   private static SqlConnection ss;
which in my deluded mind I was going to instantiate in the class constructur

When trying to register an assembly as anything but UNSAFE in SQL Server 2005
sp1, I receive the following error:
An error occurred while gathering metadata from assembly 'xxx' with HRESULT
0x80004005.

I have created a CLR Stored Procedure that is activated from a trigger.
I am trying to update a field in the same row that was Inserted.  
This is certainly allowed in purely T-SQL based triggers.  I have checked.
When I do the insert I get:

I have created a stored procedure that I call in an Insert trigger.  I want
to update the same row that I have just inserted.  I am able to do this in
T-SQL ie update a field in a row that has just been inserted with an insert
trigger.