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
the SAP ASE 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'