Fast-logged bcp

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'