UseBulkCopyOption Property (SQL-DMO)

The UseBulkCopyOption property determines whether the select into/bulkcopy option is turned on automatically when the ImportData method of the Table object is executed.

Applies To

BulkCopy Object

Syntax

object.UseBulkCopyOption [= value]

Part Description
object Expression that evaluates to an object in the Applies To list
value True or False

Remarks

If True, and the select into/bulkcopy database option is off in the target database, the option is turned on before an ImportData bulk copy is started and is turned off after the bulk copy is complete.

If False, no adjustments to the database options are made.


Important The select into/bulkcopy database option allows nonlogged alteration to the target database. A target database should be backed up after any nonlogged actions against it. For more information, see Nonlogged Operations.


Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetUseBulkCopyOption(LPBOOL pRetVal);

HRESULT SetUseBulkCopyOption(BOOL NewValue);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.