• Hmmm, that bonus question has made it kind of quiet around here until Tim came through.

    Tim Wilson-Brown

    The answer to the bonus question is to use DBCC CHECKIDENT without reseeding

    This will work if you can catch the dbcc output. The bonus bonus question: how do we interrogate the 'dbcc checkindent' output in tsql.

    Raymond