Calling a web service from a CLR SQL stored procedure

Hi,
I am trying to call a remote webservice from within SQl server using CLR.
However, SQL Server gives me an error saying that load(), loadModule() etc
are disabled. Of what I can tell, C# needs to dynamically generate and load
the XML serialization for the web service call. Does anyone know how I can
get around this problem?
Platform: SQL Server 2005 + C# (.net 2.0)Please use the beta newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Krishna" <Krishna@.discussions.microsoft.com> wrote in message
news:B5643087-4F83-4EB6-AA7E-12D7CF6C6DEF@.microsoft.com...
> Hi,
> I am trying to call a remote webservice from within SQl server using CLR.
> However, SQL Server gives me an error saying that load(), loadModule() etc
> are disabled. Of what I can tell, C# needs to dynamically generate and
> load
> the XML serialization for the web service call. Does anyone know how I can
> get around this problem?
> Platform: SQL Server 2005 + C# (.net 2.0)