dbcc object_atts:
Reserve, display, or modify an attribute on an OAM page

Syntax:
dbcc object_atts(objname, att_num, option [,put_value])

objname    -  Name of object in the current database

att_num    -  The attribute number to be accessed.  Currently
              the only available attribute is for identity and
              the att_num for it is 0

option     -  Action to take place.  Possible values are:
              get       Retrieve the current attribute data.
              put       Modify att_num with the value specified in
put_value.
              reserve   Reserve the att_num on the OAM page.

put_value  -  The value in hex to be used with the put option.

You have to grant role "sybase_ts_role" to your user id.

It returns output like:-
9de2a918:  00000000 00000047 00000000 00000000  .......G........

Where x'47' is the current identity value, for that object.

BTW: If you're creating a test table you have to quit your ISQL session
after you insert rows, then start a new session to issue the dbcc
command.

The "put" option, (to reset the identity value), required a shutdown
nowait, we found bcping out, dropping the table and bcping in reset
identity to 1. We didn't have dependent DRI constraints on the table in
question.