In the case above, I resorted to using DELETE FROM statements for each table, and suffered the performance penalty. What I would have preferred is the ability to run a SQL script to delete all the ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database.

Joey on SQL Server How To Automate Tasks in Azure SQL Database Knowing how to automate tasks in the cloud will make you a more productive DBA.