What error message means?

Results 1 to 3 of 3

Thread: What error message means?

  1. #1
    Join Date
    Dec 1969

    Default What error message means?

    "Cannot insert explicit value for identity column in table &#039;TransactionsTemp&#039; when IDENTITY_INSERT is set to OFF."<BR><BR>I don&#039;t understand the message, so I can&#039;t fix it. My table has Identity checked and identity send and increment set to 1. I am copying records from another table (Transactions) of identical design. I also tried copying evrything except the identity column, but I still get the error message.<BR><BR>Pls. help.

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default Means

    you are trying to insert a value into am identity column.<BR><BR>

  3. #3
    Join Date
    Dec 1969

    Default RE: Means

    this is in an DTS package right? There is an option "Allow Indentity insert" ore something like that. Make sure it checked

Posting Permissions

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