You may need to look into the transaction log mechanism to get a clear
picture.That shld help in the long run.
For that pls refer
As Sue mentioned in your earlier post ,you can consider doing the delete in
chunks, a number of records at a time..and in tandem monitor the log file
A very basic example from BOL...
Use DELETE and a SELECT with the TOP Clause
Because a SELECT statement can be specified in a DELETE statement, the TOP
clause can also be used within the SELECT statement. For example, this
example deletes the top 10 authors from the authors table.
FROM (SELECT TOP 10 * FROM authors) AS t1
WHERE authors.au_id = t1.au_id
> Dear all,
> How can I Removes all rows from a table which match certain condition
> without logging the any records in Transaction Log file.
> I know truncate table which will reomve all rows. I need to remove only
> rows which match certain condion.
> Appreciate any of your tips and ideas.
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!