User Profile

Collapse

Profile Sidebar

Collapse
rorajoey
rorajoey
Last Activity: Jan 20 '09, 05:45 PM
Joined: Jan 20 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • rorajoey
    replied to [SQLServer] Violation of UNIQUE KEY constraint
    in SQL Server
    Found the problem.

    As it turns out, the index was set on a column other than the primary key column. I don't see how that could have happened, so I'm still perplexed (and inclined to blame Microsoft SQL Server Management Studio), but at least I can move forward with this project.
    See more | Go to post

      Leave a comment:

    • rorajoey
      started a topic [SQLServer] Violation of UNIQUE KEY constraint
      in SQL Server

      [SQLServer] Violation of UNIQUE KEY constraint

      [SQLServer]Violation of UNIQUE KEY constraint 'IX_surveyQuest ions'. Cannot insert duplicate key in object 'dbo.surveyQues tions'.

      This might seem like a simple matter of trying to insert a row with ID=20 when there's already one with that ID, but the problem is a bit more complicated. The table is supposed to auto-increment the value for the primary key when a new record is inserted. But no matter what I do, I can't seem to insert...
      See more | Go to post
      No activity results to display
      Show More
      Working...