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 |
|
Lady
Starting Member
32 Posts |
 Posted - 2002-10-10 : 10:53:09
|
| HI!how shell i turn out writing in transaction log when I delete 10000 records from diferent tables?Edited by - Lady on 10/10/2002 10:53:27 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-10 : 11:00:20
|
| If you mean you don't want the DELETE operation to be logged, that's not possible. All DELETE operations are logged.If you need to COMPLETELY EMPTY a table, you can use TRUNCATE TABLE to do so. It will only log page deallocations, not deleted rows, and will not fill the log with as much information. However, if you only need to DELETE certain rows and not others you can only use the DELETE command. |
 |
|
|
|
|
|
transaction log and big amount for delete