cfd37d54   
   From: esquel@sommarskog.se   
      
   Spero (robspero@gmail.com) writes:   
   > I am really finding it hard to believe that this question does not   
   > come u more. I already have the soap structure completed, I can pull   
   > values from ,y table tou phrae my request. I just can not believe that   
   > this is more commonly used method to eliminate the middel ware and   
   > have the server do the work. I can not find one example. The   
   > applicartion is already completed in vb.net and just want the server   
   > to make these request. I can not find one example of a stored proc   
   > that does anything in anyway like what I need! I mean am I just asking   
   > the question incorrectly?   
      
   If you already have the code in VB .Net, all you need is to package it   
   as a stored procedure. If you have no experience of using the CLR in   
   SQL Server, you can read about it in Books Online. Since you already   
   .Net you should get going quickly.   
      
   However, I am not sure that if I were the DBA, that I would like to see   
   server threads to be stalled while waiting for reponse from a web service.   
   Then again, it depends on what environment your application will run in.   
   If this is intended for desktops solutions that will run on Express,   
   there will be no DBA to hassle you. :-)   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)