Delete error: Key column information is insufficient or incorrect

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nomi12344
    New Member
    • Nov 2011
    • 2

    Delete error: Key column information is insufficient or incorrect

    I have Accounting software which is prepared in VB, SQL server. Actually when I delete one or both of the rows containing “InOutHistory” by using SQL Enterprise Manger with the following steps;
    1. Right-click on the table.
    2. Click on Open table, and then click on Return All Rows.
    3. Highlight the rows, and then press the Delete button.
    I received this message "Key column information is insufficient or incorrect. Too many rows were affected by update."
    Kindly tell me how can delete these rows.
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    Use a query window and delete it via T-SQL.

    Good Luck!!!


    ~~ CK

    Comment

    • nomi12344
      New Member
      • Nov 2011
      • 2

      #3
      Can you tell me in detail? How can do? I have no idea about this

      Comment

      • gpl
        New Member
        • Jul 2007
        • 152

        #4
        Its a bit dangerous to do this if you arent sure of the syntax

        Could you try deleting a few rows at a time in Enterprise Manager ?

        Comment

        • Rabbit
          Recognized Expert MVP
          • Jan 2007
          • 12517

          #5
          Add an identity column and then delete the rows.

          Comment

          • pooja rani
            New Member
            • Nov 2011
            • 2

            #6
            i think the table has referential integrity constraint i.e foreign key

            Comment

            Working...