• Article

TableLock 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 TableLock property specifies whether to set table-level locking during the execution of a bulk-copy import command.

Syntax

object
.TableLock [= 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 GetTableLock(LPBOOL pRetVal);
HRESULT SetTableLock(BOOL NewValue);

Remarks

TableLock is set to FALSE by default.

Applies To:

BulkCopy2 Object