SelectIntoBulkCopy Property (SQL-DMO)

The SelectIntoBulkCopy property enables nonlogged operation on a Microsoft® SQL Server™ database.

Applies To

DBOption Object

Syntax

object.SelectIntoBulkCopy [= value]

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

Remarks

If True, nonlogged operations are allowed.

If False, nonlogged operations are not allowed.


Important Nonlogged operations make no entry in a database transaction log. Therefore, a backup of the transaction log does not protect database integrity. After performing a nonlogged operation, a database backup should be performed to capture an image of the database. For more information, see Backing Up Nonlogged Operations.


Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetSelectIntoBulkCopy(LPBOOL pRetVal);

HRESULT SetSelectIntoBulkCopy(BOOL NewValue);

  


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