SelectIntoBulkCopy Property

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能，並計劃修改目前使用此功能的應用程式。

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

語法

object
.SelectIntoBulkCopy [= value]

Parts

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

• value
  TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

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

備註

If TRUE, bulk-logged operations are allowed.

If FALSE, bulk-logged operations are not allowed.

重要事項：
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 SQL Server 中的還原和復原概觀.

Applies To:

請參閱

參考

RecoveryModel Property

說明及資訊

取得 SQL Server 2005 協助