By temp table i meant the one created by select..into..where 1=0 statement ran on source server, which has the only use for...

Mahesh Bote (4/14/2008)

---

[font="Verdana"]

try this ...

Select * Into {New Table Name} From {Old Table Name}

This will create new table with the data and structure of old table. And if you want...