If you want to transfer both data and schema (table schema and indexes),
you can use SQL 7.0/2000 DTS tool to export data from one server to
another, just need to choose the option "transfer objects" instead of the
default "transfer tables", so that indexes will be transfered as well.
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit