I'm creating a DTS task in SQL Server 2000 that includes the following (so far). SQL Server connection that runs a stored procedure and returns a set of data. Excel connection to an excel file on my ...

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. (we need to copy an old ...