Error while Simultaneous Switching and BCP in same table

• saum70

  SSC Eights!

  Points: 995

  More actions

  July 17, 2024 at 9:20 am

  #4437163

  Hi,

  Our application is created in VC++. We have House keeping process in which the data from main table A is transferred to another table  B using Switching method(yes both table has partition). the data in table A is inserted using BCP. The records get successfully inserted.

  Now when the insertion process is going on and simultaneously switching process starts, we are getting error bcp_init "table name" failed.

  Kindly guide which dmv query will help in finding the exact issue and solve this issue.

  Regards,

  Saumik Vora

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  July 18, 2024 at 10:10 am

  #4437846

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.