• I would use the the TRUNCATE command. The deletions will not be logged in the transaction log. e.g.

    TRUNCATE TABLE authors

    You need to be either a member of the sysadmin role the database owner or a member of the db_ddladmin to run this command

    hope this helps

    Dave