I just discovered, the server we are moving the table from is running SQL 6.5
- the server we are attempting to move the table to is running SQL 2000.

First I would script the CREATE TABLE command in 6.5, and run it in
the target database on 2000.  The 6.5 management tool can generate the
script for you.

To move the data I suggest using the data import wizard, which will
build a DTS process to perform the transfer.

In SQL Server 2000's SQL Enterprise Manager, navigate to the database
where you want to create the table.  Right click on it, All Tasks,
Import Data.  For the source you will specify the 6.5 server, and the
appropriate database.  Since it is 6.5 you might have to try ODBC
instead of OLE DB.  As you proceed through the process specify the
table you already created on the target SQL Server 2000 server.  It is
worth realizing that toward the end of the wizard process you have the
option of saving your work so it can be run again, and modified, which
I always find to be a good idea.

Hope that is enough to get you started.

Roy Harvey
Beacon Falls, CT

SQL SERVER - 2005 - Create Script to Copy Database Schema and All The
Objects - Stored Procedure, Functions, Triggers, Tables, Views, Constraints
and All Other Database Objects

Following quick tutorial demonstrates how to create T-SQL script to copy
complete database schema and all of its objects such as Stored Procedure,
Functions, Triggers, Tables, Views, Constraints etc. You can review your
schema, backup for reference or use it to compare with previous backup.

Step 1 : Start

Step 2 : Welcome Screen

Step 3 : Select One or Multiple Database
If Script all objects in the selected database checkbox is not selected it
will give options to selected individual objects on respective screen. (e.g.
Stored Procedure, Triggers and all other object will have their own screen
where they can be selected)

Step 4 : Select database options

Step 5 : Select output option

Step 6 : Review Summary

Step 7 : Observe script generation process

Step 8 : Database object script generation completed in new query window

Reference : Pinal Dave (http://www.SQLAuthority.com), All images are
protected by copyright owner SQLAuthority.com