In Enterprise Manager I have not been able to copy column headers in Query Analyzer. Instead I create and run the query in the "View Designer", then use shift and arrow keys to highlight all the columns, then copy and paste. Do not need to save as a view, just use its query builder. 😎