SrcName (9/20/2013)
use truncate statement. it has many adventagesBecause truncate has not where clause and you need some data, then you can save them in another temp table, truncate base table and restore data.
NO. i think Srcname you havent read the OP issue completely. its a case of purging the data.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)