leave less space if you do not use,

or you can use Property-Layout to specific the page size.

sorry wrong typing ,

try this.

with cte as (

Select top 10 *

From dbo.localtable)

select * from cte

INTo linkedserver.mydatabase.dbo.testtable

Select s.*

INTo linkedserver.mydatabase.dbo.testtable

From

(Select top 10 *

From dbo.localtable) as s

this may help you

I will give another example use cte,becase we discuse sql2005

with ...

I will give you a example again

I think use this ,you can use little C# or VB code to complete your task.

select logdate, prodgroup ,...