Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pradyumnas
Starting Member
1 Post |
 Posted - 2005-06-01 : 18:31:08
|
| I have a table with 1498726 number of rows. I am trying to import this table into the database and the import fails. This is because the transaction log is getting full. Is there a anyway i can load this table? Need Suggestions.Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-01 : 18:57:42
|
| How are you importing it? If this is via DTS, then double click on the transformation, goto Options tab, change the Insert batch size to say 10000. It'll commit the rows after each batch thus freeing up the tlog.Tara |
 |
|
|
|
|
|
Problem with importing