Table 4-2: Steps for copying in data using fast bcp
Step
|
Who can
do it
|
|---|
Use sp_dboption to
set select into/bulkcopy/pllsort to true.
Run checkpoint in the database that was
changed.
|
System Administrator or
Database Owner
|
Have enough
space to re-create any indexes and triggers on the table.
Drop the indexes and triggers on the table.
|
Table owner
|
Have insert permission
on the table.
|
Granted by the table owner
|
Perform the
copy with bcp.
|
Any user with insert permission
|
Re-create
the indexes and triggers.
|
Table owner
|
Reset sp_dboption,
if desired, and run checkpoint in the database
that was changed.
|
System Administrator or
Database Owner
|
Use dump
database to back up the newly inserted data.
|
System Administrator,
Operator, or Database Owner
|
Run stored
procedures or queries to determine whether any of the newly loaded
data violates rules.
|
Table owner or stored
procedure owner
|
