SQL Server Performance

Enable identity insert

Discussion in 'SQL Server DTS-Related Questions' started by eclair21, Jan 17, 2005.

  1. eclair21 New Member


    Can someone tell me what the function of the checkbox "enable identity insert" is when creating a DTS using the import/export wizard?

    What difference doe it make if it is selected/not selected?
  2. FrankKalis Moderator

    Well, the name is pretty much self-describing. When this option is set, you can explicitely insert values into a column having the IDENTITY property defined in it.

    --
    Frank
    http://www.insidesql.de
  3. mmarovic Active Member

    I gave a basic dts training recently and I was surprised that someone inserted identity values without checking this option. Thanks for reminding me to examine the issue.

Share This Page