Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

SelectIntoBulkCopy Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The SelectIntoBulkCopy property enables bulk-logged operation on a Microsoft SQL Server database.


object
.SelectIntoBulkCopy [= value]

object

An expression that evaluates to an object in the Applies To list

value

TRUE or FALSE

Boolean

Read/write

HRESULT GetSelectIntoBulkCopy(LPBOOL pRetVal);
HRESULT SetSelectIntoBulkCopy(BOOL NewValue);

If TRUE, bulk-logged operations are allowed.

If FALSE, bulk-logged operations are not allowed.

Important noteImportant

Bulk-logged operations make no entry in a database transaction log. Therefore, a backup of the transaction log does not protect database integrity. After a bulk-logged operation is performed, a database backup should be performed to capture an image of the database. For more information, see Restore and Recovery Overview (SQL Server).

Community Additions

ADD
Show:
© 2015 Microsoft