Deleting large number of rows

do it in batches.. use SET ROWCOUNT to limit the rows...