Thursday, February 16, 2012

Bypass transaction log

Hi,
I have a database in full mode, can i issue a delete
command that deletes a single row bypassing the
transaction log?
Thanks in advance
MiguelYou can use TRUNCATE TABLE to delete the contents of the
entire table without logging. I am unaware of any way to
do this at the row level.
>--Original Message--
>Hi,
>I have a database in full mode, can i issue a delete
>command that deletes a single row bypassing the
>transaction log?
>Thanks in advance
>Miguel
>.
>|||That's not possible.
Linchi
>--Original Message--
>Hi,
>I have a database in full mode, can i issue a delete
>command that deletes a single row bypassing the
>transaction log?
>Thanks in advance
>Miguel
>.
>

No comments:

Post a Comment