|
|
sybperl-l Archive
Up Prev Next
From: "Pauline Biron" <Pauline dot Biron at MCI dot Com>
Subject: Identity Burn Set Factor
Date: Oct 8 1997 8:47AM
Hello!
A sybase, not sybperl question. I'd appreciate any insight.
Our Sybase machine crashed last week, and the identity fields within
the database tables reset to 5trillion. We have reset the burn set
factor to 20 (rather than the default 5000). I would like to restore
the original seed value of the identity column. The 5 trillion id is
too much for me to deal with. Is there a way to reset the identity
fields without recreating the table and bcping the info back into it?
Or is this the best/only way?
Regards,
Pauline Biron
****************************
Pauline.Biron@MCI.Com
Developer, GTSS Web Group
V968.7651
(919)461.7651
|
