Hi Vijaya Kumar,

recently i have read your article and it's helpful.And I have small doubt why are you used this,

(This works for Oracle but not MSSQL)

"I have used “Truncate” statement instead of “Delete” because I do not want to rollback my data."

when you Truncating records...B'cos Truncate also can be ROLLBACK...

Thanks

Tharindu Dhaneenja