Microsoft KB Archive/269971

= BUG: TableIsLockedOnBulkLoad Property not Listed in SQL Server Books Online for OBJECTPROPERTY =

Article ID: 269971

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



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 &quot;Table Lock on Bulk Load&quot; 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.

Keywords: kbbug kbpending KB269971

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.