How to 'select' the current identity value for a table?

Question

dbcc checkident (MyTable, NORESEED)

Will show the identity value in a message. I can't see the message as I need to select the identity value through a DataReader.

Anyone any ideas?

Thanks folks

Answer 1

SELECT IDENT_CURRENT('MyTable')

See BOL

Answer 2

SELECT IDENT_CURRENT('TABLE_NAME')

returns NULL if there is no identity defined in the table