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 ...

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.