Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ken Blum
Constraint Violating Yak Guru
383 Posts |
 Posted - 2003-08-26 : 14:18:01
|
| When I use DTS to copy a table to the same DB (or I imagine another DB) with a different name none of the index setup/structure is copied. What am I missing?Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-26 : 18:45:43
|
| DTS does not do this for you. You will need to generate the script and then create the table using this script. After that, run DTS. DTS only creates the base table for you.Tara |
 |
|
|
Ken Blum
Constraint Violating Yak Guru
383 Posts |
Posted - 2003-08-27 : 11:37:47
|
| OK Thanks! |
|
|
|
|
|
|
Copy Index with DTS table export