Empty all table or delete all data from all table by sp_MSforeachtable in SQL-SERVER 2005
As a developer, many times we need to delete all the records from all tables. For example we are developing one application in our development server. At the time of developing we must have entered lots of temporary data in our database; we shouldn’t upload all those data along with structure at live server. We should have to delete all dummy and temp data.
Note: This article is moved to following URL on 6th NOV 2012. Kindly use following link: