Ian,
I too was going to post a script to do the job, but the drag/drop method is waaaaaaaaaaay better! 😎
Here it is anyway
create proc print_select_for
@table varchar(128)
as
begin
declare @s-2 varchar(max)
set @s-2=''
select @s-2=@s+case ordinal_position
when 1 then 'select '
else ', '
end+char(13)+' '+column_name
from information_schema.columns
where table_name=@table
order by ordinal_position
set @s-2=@s+char(13)+'from'+char(13)+' '+@table
print @s-2
end
go
exec print_select_for 'something'
Derek