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: "Randev, Rajesh, OPLS" <rrandev at att dot com>
Subject: RE: Identity Burn Set Factor
Date: Oct 8 1997 5:07PM

	As suggested by Michael Peppler to rename the original tables
	and select into to create fresh, please be noted that when u use
	'select into' - the rules & defaults attached to the columns will not
	be copied..
	Thanks
	Rajesh Randev.

>----------
>From: 	Michael Peppler[SMTP:mpeppler@mbay.net]
>Sent: 	Wednesday, October 08, 1997 11:02 AM
>To: 	SYBPERL-L@trln.lib.unc.edu
>Subject: 	Re: Identity Burn Set Factor
>
>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
>
>