SQL Server 2005 or later script to generate TRUNCATE statements ... I present the source code for a Visual Basic program to generate a SQL script to efficiently delete all data from a database ...

Conversely, the delete command removes ... available port is chosen when SQL Server starts. When connecting to a named instance through a firewall, configure the Database Engine to listen on ...

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. In part one of this article, I described a ...