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 ...
What is the best way to do this? File locations will be different on new server.<BR><BR>Should I SP_DETACH_DB the source DB, copy over the .mdf/.ldf files, then SP_ATTACH_DB on destination server with ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback