What is the size of the database?
What is the speed of the connection between servers?
What is the record count to be deleted?
Those answers will help to understand a better approach.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events