BUG: TableIsLockedOnBulkLoad Property not Listed in SQL Server Books Online for OBJECTPROPERTY (269971)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q269971
BUG #: 235336 (SHILOH_BUGS)

SYMPTOMS

In SQL Server 2000, you should use OBJECTPROPERTY to return information about objects in the current database. Microsoft SQL Server Books Online lists the names of all the properties that you can query on and you can get information about an object in the OBJECTPROPERTY topic. However, the TableIsLockedOnBulkLoad property is not listed in SQL Server Books Online. You use TableIsLockedOnBulkLoad to check if the "Table Lock on Bulk Load" option is set.

WORKAROUND

To work around this problem, you can use the following query to get information you need: 
SELECT OBJECTPROPERTY(OBJECT_ID('object_name'),'TableIsLockedOnBulkLoad')
A value of 1 means that a table lock is set on Bulk Load. A value of 0 means that a table lock is not set on Bulk Load.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 2000.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbpending KB269971
©2003 Microsoft Corporation. All rights reserved.