Hello, I need to copy a mass amount of tables in SQL Server to the same database (obviously renaming the tables). I need to include constraints, keys, indexes, etc, as well as data. So for example ...

They have their own server with a SQL Server database holding the data for the live site. So as not to interfere with their live data during development, we have a backup of their data installed ...

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 ...