<div>
would you know how to use DTS<br />

</div>


<div>
DTS is all prompts. &nbsp;Just follow the prompts and you can just click click your way to copying. &nbsp;The above query also works and is just as easy if you are familar with SQL.
</div>


DTS is all prompts.  Just follow the prompts and you can just click click your way to copying.  The above query also works and is just as easy if you are familar with SQL.

<div>
I tried using DTS and it works fine but I just want to move the table and not the data, do you guys know how to do that in DTS, Thanks
</div>


I tried using DTS and it works fine but I just want to move the table and not the data, do you guys know how to do that in DTS, Thanks

<div>
<div class="content wysiwyg-content">
How to move table from one database to another database in sql server 2000<br />
<br />
Any help will be greatly appreciated
</div>
</div>


How to move table from one database to another database in sql server 2000

Any help will be greatly appreciated

How to move table from one database to another database in sql server 2000

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.