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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-12-19 : 09:00:41
|
| Goekhan Guemues writes "dear friends;in Oracle; i can delete records without transaction. In sql plus;you can write SET COMMIT OFF and after executing this statement;you can delete records without transaction etc.in ms sql server; when i want to delete records in a table; the transaction log growths its size. But i want to delete records for ever without transaction and bypassing transaction log.yes friends, how can i delete records in autocommit state.thanks" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-19 : 09:03:17
|
| If you want to delete all the records then Truncate the tableTruncate table tableNameMadhivananFailing to plan is Planning to fail |
 |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2005-12-20 : 00:23:06
|
| Hi,may suggest to read following link to understand it more :http://www.sql-server-performance.com/q&a118.asphttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11469:-)RegardsAndy DavisActivecrypt Team--------------------------------------------SQL Server Encryption Softwarehttp://www.activecrypt.com |
|
|
|
|
|
|
How, Autocommit delete?