You could use the SQL Server Import & Export Wizard to Transfer data from one table to another table

You could download the sql express edition toolkit from the link below. The DTSWizard comes with the Microsoft SQL Server 2005 Express Edition Toolkit


http://www.microsoft.com/DownLoads/details.aspx?familyid=3C856B93-369F-4C6F-9357-C35384179543&displaylang=en

D:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe

I have tried following query for the same purpose and it worked for me
SELECT INTO STAFF FROM Example1.dbo.staff
I have executed the query in the destination database