sorry (duplicate)

Mike,

Thanks.

I was trying to select a large dataset, from a read-only SQL Server database (that is, the data is stored on ServerA in #tmp_tbl)... and insert the data...

Dwain,

Technically, does the 'into' clause create a temp table in the tempdb. Thus, do I need more the 'public' permission to tempdb? That is, do I need dbwriter...

Dwain,

Thank you very much,

J

Thanks Abu, this really helps.

j