Post reply

need to interrogate dbcc "print" results

  • November 27, 2006 at 4:43 pm

    #175473

    I need to be able to interrogate the results of a "dbcc checkident" from a tsql procedure.

    I cannot get checkident to return results as a table and am having a hard time figuring out how to intercept/obtain the "print" output from checkident within the tsql script.

    Any takers?

  • November 27, 2006 at 4:53 pm

    #674198

    Why would anybody need it?

    _____________
    Code for TallyGenerator

  • November 28, 2006 at 4:47 am

    #674295

    Because I need advance warning before the (integer) ident value is going to overflow.  max(ident_column) will not work because it may have already been reset to zero but there are also high values at the top-end that have not yet been removed from the table.

  • November 28, 2006 at 9:40 am

    #674434

    never mind... this is much more easily done by querying sysobjects directly.  sorry to bother.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply