BUG: DOC: Information About Nonlogged vs. Logged BCP Incorrect

ID: Q234806

The information in this article applies to:

Microsoft SQL Server version 7.0

BUG #: 55814 (SQLBUG_70)

SYMPTOMS

The Logged and Nonlogged Bulk Copy Operations topic in SQL Server Books Online states the following regarding the logging of bulk copy operations:

"Additionally, if the table has any indexes, then there should be no existing rows in the table to perform a nonlogged bulk copy. The combination of indexes and existing rows of data cause the bulk copy operation to be logged."

This is incorrect. Regardless of whether the table contains data, when the following conditions are met:

The Select Into/bulkcopy database option is set.

The target table is not being replicated.

The TABLOCK hint is not specified in the bcp.

the following is true:

If an index exists on the table, the bulk copy operation IS NOT logged.

If no index exists on the table, the bulk copy operation IS logged.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

Additional query words:

Keywords : kbSQLServ700bug
Version : winnt:7.0
Platform : winnt
Issue type : kbbug