SQL Server 2005 or later script to generate TRUNCATE statements for all tables. Anyone that has tried this on anything but the most simplistic database has found, as I did, that this won't work.

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.

While temporal data support is something that has existed in the past within other database platforms, it is a newly available feature with the RTM version of SQL Server 2016. In case you haven't ...