bcp and block tables

• fasttrack

  SSCertifiable

  Points: 6071

  More actions

  July 18, 2005 at 2:40 pm

  #90118

  I'm building a stored procs which export a series of tables in file *.dat using bcp and import the same with bulk insert. 

  my question is:

  If the DB from which the tables are copied is a run-time DB, I mean that tables are continuolsly update,deleted and inserted, can happen that during copy a record is not copied entirely?

  There is a block table during bcp copy?

  thank in advance

  

• Dave-3000

  SSCertifiable

  Points: 6186

  More actions

  July 18, 2005 at 3:39 pm

  #575342

  bcp will write the resultset of a query out to a file. So whatever the result of that query happens to be at the time of execution will be written.

  There is no "i" in team, but idiot has two.