Michael Earl (5/19/2008)
Assuming you have both databases test and test2 running on the same server:[font="Courier New"]use test
select testTable1.*
into test2.dbo.testTable1
from testTable1
go[/font]
cheers that did the job okay what about if they are...