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: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Re: Identity Burn Set Factor
Date: Oct 8 1997 3:02PM

Pauline Biron wrote:
> 
> 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?

Assuming you have enough space, how about renaming the original table,
and then using select into to recreate the original table (with
identity_insert on, of course).

Michael
--
Michael Peppler       -||-  Data Migrations Inc.
mpeppler@datamig.com  -||-  http://www.mbay.net/~mpeppler