Mohammad Fawaz

To empty large table in SQL, Usually it need looooong time to finished. but you can do this by using the below command:

set rowcount 1;

truncate table TABLE_NAME;

For more:
http://khaled-abrass.blogspot.com/2010/02/how-to-delete-or-truncate-large-table.html