SQL Server identity column problem

Results 1 to 2 of 2

Thread: SQL Server identity column problem

  1. #1
    Beno Guest

    Default SQL Server identity column problem

    Does anybody know why my SQL server(6.5) seems to loose the information of the identity column, and obviously I receive errors when I try to insert a record because it tries to insert a 1 into the identity column which already exists. It doesn&#039t happen frequently, but it happens with no apparent reason.<BR><BR>Can someone help me?

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Server identity column problem

    I have seen this problem many times on SQL 6.5 -- the good news is that it doesn&#039t seem to happen to me on SQL 7.0 -- <BR><BR>Of course that doesn&#039t fix your problem. There is a sp you can run that should fix the problem. It is been a while since I used it but it is something like sp_checkident TABLENAME look it up if you are needing a fix.

Posting Permissions

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