About Us   SSWUG Articles   Articles   FAQ   Administration   Backup/Restore   Connectivity   Development   General   Installation   OLAP   Replication   Transfer/move   Trouble   SQL 6.5   Scripts   Tips   Test Exams   Advertise   Download   History   Search   Traffic   Related Links         Add to Favorites

How can I perform a nonlogged bulk copy? Answer: The following conditions should be met for nonlogged bulk copy: The database option select into/bulkcopy is set to true using sp_dboption. The target table is not being replicated. The TABLOCK hint is specified. If the table has any indexes, then there are no existing rows in the table.

Visit The SQL Server Worldwide User's Group for all the latest news and information about SQL Server, Oracle, DB2 and XML for developers and administrators. (c) 1997, 2010 Bits on the Wire, Inc