Post reply

How to use "set identity_insert off" along with BCP -in

  • December 28, 2004 at 5:22 am

    #535121

    Have you looked at bcp's -E option?

    /Kenneth

  • December 29, 2004 at 8:33 am

    #535275

    Hi Kenneth,

    I tried that & its found working.

    Because of this problem I got to learn about SET IDENTITY_INSERT off &

    DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value) properties

    Thanks for your help.

     

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply