Home Forums SQL Server 2008 T-SQL (SS2K8) sp_OAGetProperty @obj, 'responseText', @response OUT cannot handle large output RE: sp_OAGetProperty @obj, 'responseText', @response OUT cannot handle large output

  • November 4, 2011 at 1:03 pm

    #1403467

    Glad i got you pointed in the right direction;

    If you can use CLR, i think there's a couple of ways you could do it that way; I had a Web Service i built once as a response to a post here where i passed the web service an URL, and it reutrne dthe html of the page found at the url;

    then i used a CLR to call the web service and return the varchar(max) string;

    I'm also under the impression you can do it with Service Broker as well, but i've never done that at all.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!