title: How to 'select' the current identity value for a table?
body: <p><code>dbcc checkident (MyTable, NORESEED)</code></p>
  
  <p>Will show the identity value in a message. I can't see the message as I need to <code>select</code> the identity value through a <code>DataReader</code>.</p>
  
  <p>Anyone any ideas?</p>
  
  <p>Thanks folks</p>