PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

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