IF you are deleting everything out of a table, try using TRUNCATE TABLE instead of DELETE. It's the SQL Server equivalent of ZAP.
>Are you familier with some of the server side params on SQL Server for example i am currently running a delete query over 5 million rows in a table just deleteing everything on MySQL and other SQL servers i have used like postgress ect.. it was always instantaneous for a query like that SQL server tends to take a year and a day any ideas???
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05