title: Get results from mssql stored procedure with jdbc
body: <p>I have quite complex stored procedure in MSSQL database that returns no value (just default integer code) and has <code>select</code> statement that produces single string (<code>'OK'</code> or error message).</p>
  
  <p>I can see this result in Management Studio's <em>Results</em> tab executing procedure with <code>exec my_procedure 'param1', 'param2'</code>. However, when I try to execute this query with jdbc <code>boolean resultExist = preparedStatement.execute(sqlString)</code>, I get my <code>resultExist</code> variable set to <code>false</code> and no result set is available.</p>
  
  <p>Is there any way to obtain result produced by stored procedure without changing it?</p>