I need to delete thousands of records from a table, probably best via SQL Query Analyser and SQL code, but the TEMPDB keeps filling-up and making the d/b "suspect" - so I cannot use it thereafter. I cannot use the TRUNCATE command because I want to delete "some" records from the table, not "all" of them, and the "delete from ..." command seems to add transactions whether I like it or not. I am not a SQL expert and am having real probs here ... can anyone help?