title: procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead
body: <p>I am using <code>execute sp_executesql</code> to execute a insert query in sp. Query executed, insert happen properly. After that I am using <code>scope indentity()</code>, value is set into one output para. But I am getting error:</p>
  
  <blockquote>
    <p><code>procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.</code></p>
  </blockquote>
  
  <p>How to solve it? Does anybody having an idea?</p>