Sorry, Forget this posting; all fixed !!

The nested sp is called by "EXECUTE spname" in T-SQL. I like the idea of referencing a temp table created in the "main"-sp in the called-sp but how can I...

Try:

SELECT * INTO NewTable FROM existingdb.dbo.existingtable;

Could it be that you meant to spell Traction as Transaction in the final FROM clause ?

I agree with David Poole. Don't forget that if you store the file as a "blob" image you will not be storing the file attributes. What I do is to...