Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Resetting Identity to the Seed Value in SQL 7.0
Message
De
22/07/1999 17:22:01
 
 
À
22/07/1999 14:05:01
Robert Byrd
National Association of Homebuilders
Washington, District de Colombia, États-Unis
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00244879
Message ID:
00245016
Vues:
25
Robert,

Check out the DBCC CHECKIDENT command. I was able to reset the identity using DBCC CHECKIDENT(table, RESEED, newvalue). It will return what the current value was (althought it say that it 'is') and the low value for the table. If you DBCC CHECKIDENT(table) you'll see that the value has been reset.

BTW, You're running 7.0 right?

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform