Sean Lange (7/17/2013)
The next issue is top(1000). You have no order by so there is no way to know which 1000 it will delete.
You can't put an Order By on a delete.
DELETE TOP (100) FROM SomeTableMsg 156, Level 15, State 1, Line 4
ORDER BY ID
Incorrect syntax near the keyword 'ORDER'.
You can put an order by into a CTE (the select) and delete from the CTE, you can put a select with order by and use IN, but you can't put an order by onto a delete directly
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass