Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Pr0ph3ts

    Auto-increment Problem

    I took a look and the constraint is on sectionID(ASC), lastPostID(DESC). But that shouldn't be creating the problem because there is never a time when a post id isn't unique.
  2. Pr0ph3ts

    Auto-increment Problem

    I have not added any trigger's recently, but i did replace @@identity, but I am still having the issue. When I try to execute the command I get the following exception: Violation of UNIQUE KEY constraint 'IX_message_topic'. Cannot insert duplicate key in object 'dbo.message_topic'
  3. Pr0ph3ts

    Auto-increment Problem

    To insert the topic info into the table we call the following the message_posttopic stored procedure, which is defined below: CREATE PROCEDURE message_posttopic @sectionID INT,@userID INT,@addusertopic BIT,@subject VARCHAR(100),@body TEXT,@topicID INT OUTPUT AS SET TRANSACTION ISOLATION LEVEL...
  4. Pr0ph3ts

    Auto-increment Problem

    I am using SQL Server and you are correct it is set as an identity column.
  5. Pr0ph3ts

    Auto-increment Problem

    Hey, Here is what happened: Users for a long time have been able to post new topics in our forums. However, a short time ago, the some users began to experience problems. What I have narrowed it down to is that upon inserting into the table, sometimes id value for the topic is the same as an...

Part and Inventory Search

Back
Top