I wonder why you require procedure. You can create the table structure in the target and use the Data ranformation services of SQL Server 2005 to move the data.

Hi Ashar!!
There is an requirement that in the front end we select table list and when we click on Move button it should cal a procedure to move those tables.Thats why preferring for procedure.

Ok. I'm not sure how to do that in procedure. may be if u have linked server, you can directly access CRM tables and insert data into it.

How do I copy certain tables from one database onto another database (both on the same server)???I am need only Structure of the table... not the contents...

I prefer creating a database link in DB2 connecting to DB1, Which can be private db link also. Just follow the usual DB link creation syntax

CREATE DATABASE LINK DB1.SAMPLE CONNECT TO HARI IDENTIFIED BY HARI USING 'DB1.SAMPLE';

Test the db link:

SELECT * FROM ;

If you want to create an empty table (structure only):

CREATE TABLE copy AS SELECT * FROM  WHERE 1 = 2;

Regards,
Hari.