title: How to avoid sp_OACreate limits?
body: <pre><code>Declare @Object as Int; 
  Declare @ResponseText as Varchar(8000); 
  Declare @Url as Varchar(MAX);
  
  set @Url = 'http://mysite.ru/cgi-bin/my_xml.cgi'
  
  Exec sp_OACreate 'MSXML2.XMLHTTP', @Object OUT; 
  Exec sp_OAMethod @Object, 'open', NULL, 'get', @Url, 'false' 
  Exec sp_OAMethod @Object, 'send' 
  Exec sp_OAMethod @Object, 'responseText', @ResponseText OUTPUT 
  Exec sp_OADestroy @Object
  
  SELECT @ResponseText
  </code></pre>
  
  <p>XML length in url is 4210 and  <code>@ResponseText</code> return <code>NULL</code> , when I change length to 3970  <code>@ResponseText</code> return me data. Does sp_OACreate have limit 400 ? If yes if it possible to avoid ?</p>