Question: how to copy table from one database to another in sql server 2008 with data?
Answer: Open SQL Server Management Studio.
Right-click on the database name, then select "Tasks" > "Export data..." from the object explorer.
The SQL Server Import/Export wizard opens; click on "Next".
Provide authentication and select the source from which you want to copy the data; click "Next".