SQL-server. How do I insert millions of...

[Powerful bliss]

...records - whithout adding data to the transaction log file?

[Agnau]

This is not exactly an answer but more of an additional question: Why in the world would you want to do that? The logs are there for troubleshooting, recovery, and rebuilding lost data.

[ltmandella]

there are "minimally logged" operations in sql server (SEE LIST BELOW), but no TOTALLY "non-logged" operations.*SELECT INTO*BULK COPY and Bulk Copy Program (BCP)*CREATE INDEX*TRUNCATE*Certain text operations (WRITETEXT and UPDATETEXT)The first two in the list above can be used to insert data into a table...