• Andras,

    t would probably be a poor choice if you do not want to get rid of every row in your table.

    You mean we need to use TRUNCATE if we dont want the log for those deleted records.

    Am i correct ?

    Since you specify a where clause, TRUNCATE is likely not what you are looking for.

    Yes, He has to use DELETE.

    karthik