Reset of Identity

Question

Reset of Identity

Viewing 9 posts - 16 through 23 (of 23 total)

You must be logged in to reply to this topic. Login to reply

SQLBlimp SSCertifiable Points: 6340 More actions · Answer 1

Found this out the hard way a fewweeks ago in a database that was part of a peer-to-peer transactional replication topology. :ermm:

Thanks for the point!

M&M SSC-Insane Points: 21700 More actions · Answer 2

M&M

SSC-Insane

Points: 21700

July 16, 2013 at 2:53 pm

#1633011

Good one.

M&M

Bangla Hall of Fame Points: 3137 More actions · Answer 3

Bangla

Hall of Fame

Points: 3137

July 17, 2013 at 4:12 am

#1633165

Nice one....

PHYData DBA SSCertifiable Points: 7541 More actions · Answer 4

Great Question. Another reason I like being able to use Truncate Table and not DELETE when trying to empty a table and reset the Identity.

sqlnaive SSCoach Points: 17437 More actions · Answer 5

Easy one for those worked on Identity columns. 🙂

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

straight forward question

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Ashok Teotia SSCrazy Points: 2407 More actions · Answer 7

in fact title of the Question is answer :w00t: :hehe:

jfgoude SSCrazy Points: 2586 More actions · Answer 8

jfgoude

SSCrazy

Points: 2586

August 29, 2013 at 8:38 am

#1646013

easy thanks

Jamie-2229 SSCrazy Eights Points: 8156 More actions · Answer 9

oops, read all the way to the end then answer... got me!

Jamie