>Hi,
>
>I need to copy a table from one database to another, on the same SQL Server. I tried using Task -> Import wizard but does not seem to give me a choice of just selecting one table. Is there a way to select just one table when Importing? Or it there another way to copy the entire table from one db to another?
>
>TIA
You can do that straight from SSMS. Right Click on the database you want to import a table into and click on Tasks and then Import Data. A wizard will walk you through it.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________