That would work if
a) I knew that the sequence was being used to create values for a column in a table, and
b) it was only used for that purpose.
Which is obviously not always the case.
Another list member suggested to me that I use LogMiner to look for changes in sys.seq$. I will try that.
-----Original Message-----
From: Daniel W. Fink [mailto:[EMAIL PROTECTED]]
If you know the field that is being populated by the sequence, examine the last 25/50 entries, determine the pattern and 'high' value, then recreate the sequence accordingly.
If you don't know the field, you can take a guess that it is the primary key (or perhaps another unique value).
