SQL-DMO
TableLock Property
The TableLock property specifies whether to set table-level locking during the execution of a bulk copy import command.
Applies To
| BulkCopy2 Object |
Syntax
object.TableLock [= value]
Parts
object
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.
Note TableLock can be used with Microsoft® SQL Server™ 2000 and SQL Server 7.0.