After you provide info about the destination for your data and about how to connect to it, the [!INCLUDEssNoVersion] Import and Export Wizard shows Specify Table Copy or Query. On this page, you ...

Both the above queries will create a new table "tblNewStudents" having same structure as table "tblStudents". The columns of table "tblStudents" along with datatype are copied but these quries will ...

To copy column definitions from one table to another You cannot copy individual columns from one table to another existing table by using Transact-SQL statements. However, you can create a new table ...

If you've been searching for a way to use the table structure in an existing Microsoft Access database in another table, then check out this quick tip. It shows how to copy and customize the table ...

I'm pretty much a beginner when it comes to SQL Server administration, so I'm kinda in the dark here.<BR><BR>BTW, both servers use SQL Server 2000.