Is there a way to delete records from table without logging

Is there a way to delete records from table without logging

Post by vive » Fri, 09 Feb 2001 11:00:25



Hi,

Is there an MSSQL equivalent of nologging (in SQL) that ORACLE provides. If there
is no option in SQL then is there a way to turn off transaction loggin using SQL
and then turn it back on agian.

I need this in order to delete a large volume of records from table quiclky.

Thanks

Vivek

 
 
 

Is there a way to delete records from table without logging

Post by Roberto Santo » Fri, 09 Feb 2001 20:57:08


Only if you want to delete all the records (empty the table), you can use
the TRUNCATE TABLE command. It logs only the page deallocations, not every
row delete. But remember: it will empty your table, all the rows will be
deleted.

Roberto Santos


Hi,

Is there an MSSQL equivalent of nologging (in SQL) that ORACLE provides. If
there
is no option in SQL then is there a way to turn off transaction loggin using
SQL
and then turn it back on agian.

I need this in order to delete a large volume of records from table quiclky.

Thanks

Vivek