Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    660

    Unanswered: how to add record with same Primarykey that user deleted

    I have a sql server database that she deleted a record with ID as 2873. I would like to try to add this record manually, but the primary key can't be edit. How can i add this record with the same ID as she deleted?

    Many thanks.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    An autonumber? Look at IDENTITY_INSERT in BOL.
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •