Use fast-logged bcp on any table the includes indexes and triggers
(bcp does not fire any triggers in the target table). Fast-logged
bcp logs inserts to tables.
Use the set logbulkcopy {on | off } command to configure fast-logged
bcp for the session. You may include the set logbulkcopy {on |
off } with the --initstring
'Transact-SQL_command' parameter, which sends Transact-SQL
commands to Adaptive Server before transferring the data. For example, this enables logging
when you transfer the titles.txt data into the
pubs2..titles
table:
bcp pubs2..titles in titles.txt --initstring 'set logbulkcopy on'