Exforsys

Online Training

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

This is a discussion on SQL-server. How do I insert millions of... within the SQL Server forums, part of the Database category; ...records - whithout adding data to the transaction log file?...


Go Back   Exforsys > Database > SQL Server

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

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply

 

LinkBack Thread Tools
  #1 (permalink)  
Old 03-19-2007, 07:10 AM
Junior Member
  
Join Date: Mar 2007
Posts: 1
Powerful bliss is on a distinguished road
SQL-server. How do I insert millions of...
...records - whithout adding data to the transaction log file?
__________________
Powered by Yahoo! Answers
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 03-19-2007, 09:10 AM
Junior Member
  
Join Date: Mar 2007
Posts: 1
Agnau is on a distinguished road
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.
__________________
Powered by Yahoo! Answers
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 03-19-2007, 10:10 AM
Junior Member
  
Join Date: Mar 2007
Posts: 1
ltmandella is on a distinguished road
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...
__________________
Powered by Yahoo! Answers
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« connect to sql server using compact framework | Where i can get the MS SQL Server Software as »

Thread Tools

Posting Rules
You may not post new questions
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
SQL SERVER CE NareshShroff Microsoft .NET Tutorials and Articles 0 08-18-2004 04:32 AM
SQL Server CE 2.0 installation Problem NareshShroff SQL Server 2005 Tutorials 2 07-17-2004 06:55 AM
Migrating Oracle Databases to SQL Server 2000 sanereddy SQL Server 2005 Tutorials 0 07-05-2004 07:37 AM
Sybase FAQ: 1/19 - index David Owen Tech FAQ 2 04-20-2004 09:45 AM
Kerberos FAQ, v2.0 (last modified 8/18/2000) Ken Hornstein Tech FAQ 0 04-17-2004 07:28 AM


All times are GMT -4. The time now is 09:39 PM.

Contact Us - Exforsys - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0
Copyright 2004 - 2007 Exforsys Inc. All rights reserved.