another @@identity problem

Results 1 to 2 of 2

Thread: another @@identity problem

  1. #1
    Join Date
    Dec 1969

    Default another @@identity problem

    I want to populate a SQL table from Access dumping Auto numbers into the identity field using SET IDENTITY_INSERT. If I make a mistake is there a way after deleting all the SQL records to reset the identitiy key back to 1 similar repair and compact in Access.<BR><BR>Thanks in advance

  2. #2
    Tim Snyder Guest

    Default Truncate?

    You can truncate the table === remaove all records and then reload.<BR>

Posting Permissions

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