Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Import without loging
Message
De
07/10/1999 17:23:17
 
 
À
07/10/1999 10:11:38
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
00273668
Message ID:
00273978
Vues:
27
I pulled this from the BOL

"...a nonlogged bulk copy can be performed if all of these conditions are met:

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. For more information, see Controlling the Locking Behavior.
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.

Any bulk copy into Microsoft® SQL Server™ that does not meet these conditions is logged. "

The last item is the stickler. If there's data in the table, you'll have to drop the indexes.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform