For the identifier delimeters (brackets), in Query Analyzer, got Tools|Options and on the Script tab you can choose from,

Version dependent

None

[] -- 7.0 compatible

" " -- 6.5 compatible

For point two, I wasn't really expecting you to do anything with your procedure. It was more to do with how things are scripted in query analyzer.

We have a couple of tables that have way too many fields. Most of my adhoc queries on these tables use a majority of the fields in the table and it always seems to be the last few that I end up removing. So I'm constantly finding myself scrolling across to find the fields to delete.

All my user written procedures stay as user procedures whether they perform system functions or not. I do have one stored procedure I put together that generate insert/update/delete procedures for our datawarehouse. I pass in a table name and it does the rest.