It would be nice if there was a way to import and export all SQL Prompt options like how you can import and export format styles.

I would like an additional option for the Inserted code > Qualification tab:

Qualify column names with table aliases only.

Most times I want to assign a table alias and use it when adding columns, however if I forget to assign a table alias or remove it, I don't want a fully qualified table name when using the Qualify column names with table name option.

I would like the option to qualify with both table names and table aliases or just table aliases and NOT table names.

To get an ALTER script for an existing stored proc or UDF you just need to right click it in Object Explorer and select Modify. For views you can't do this. You have to select "Script view as.." then "Alter to..." then "New query editor window". It's only two extra mouse clicks but they are two very annoying mouse clicks! I was hoping this would have come back for SQL2012 as you used to be able to do this in SQL2000, but it hasn't. Redgate to the rescue?

Double clicking a word hightlights all instances of that word. This makes it easier to see where the word is used. Good for particularly long scripts.
Double clicking a table, column, function, view etc. highlights all in your script.

It would be great if the Options-forms was resizable (and the formsize was stored when closing the form).

The 'Sample SQL' textbox would then be larger so all SQL code is visible with the formatting options that are chosen.

1)Automatically name tabs generated by modifying a stored procedure in the Object Explorer. I noticed you added the functionality to right-click on a procedure name in-line and generate an ALTER script. That's AWESOME, and even more awesome is the fact that the tab is named by default. Usually tabs in SMS have some dynamically-generated name that's useless.
2) add ability to rename a tab without saving the contents of the tab. Just a right-click->Rename
3) Hovering over a tab should give you a pop-up with the first dozen or so lines of text in that tab.

1) add a possibility to set custom colours to tabs
2) pin in/pin out tabs
3) automatically set colour for executing queries tabs
4) add possibility to pop-up windows when query execution finish

I'd like to enable schema collection when I'm writing code, and disable it when I'm doing adhoc queries. Why: We have 100 identical databases with 1900 tables in each database. When I run a query that pulls data from each database sqlprompt starts collecting schema data from all 100 databases, then it runs out of memory and crashes.
The "Turn Off Prompting" option does not help.

example:
select id,customer from DB1.dbo.orders where date > @d
union select id,customer from DB2.dbo.orders where date > @d
...etc...

This would make Sql Doc a lot more useful if the information you entered was displayed along with the other nicely formatted information in the popup window in Sql Prompt for table, stored procs, etc.

I frequently need to work on longer procedure or scripts, and the longer the script gets Sql Prompt gets more and more bogged down, to the point I just turn it off. It would be nice to be able to toggle it from the toolbar rather than open the options to un-check 'Use SQL Prompt'

Some users report that having to go into options to disable prompt temporarily is long winded. Can there be a quicker way (perhaps a keyboard shortcut or direct menu option)?

Coloring the Tabs is very nice. I would love to have the database/server icons be colored (or at least a small colored dot on them) so I could see at a glance in Object Explorer what server the database is on.

In Object Explorer you can filter tables. It would be nice if these filters could be persistent. That is that they would remain when you restart SSMS (Actually MS should fix this)

It would be nice to compare 2 objects (tables / stored proc ets), by right clicking on them and select to compare (lig scema compare).

I am using to to clean up an old DB with a lot of copyed code and tables.

The reason I would like to see the folders is strictly for organizational purposes. I have so many procedures and tables in one database that I have to scroll through them all to find what I’m looking for. If I could organize by schema (or however I choose) and very quickly and jump back and forth between the different folders, that would help me out tremendously. The SQL filter function is so slow when going back and forth.

What if I could organize sql instances that I'm connected to in one SSMS. Production and Development folders?? Just another thought.

Make SQL prompt workgroup aware, so that several people in a workgroup can share snippets, formating templates, alias lists and other useful common configurations

Show a visual indication when open transactions exist in a query window (@@TRANCOUNT > 0)

It could be changing the background color of the query window, and a number in the status bar showing the current transaction depth or something like that.

At the moment, only 4 options are available in the [Options] -> [Tabs & Wrapping] -> [Characters per line] option. The value can also be changed manually by direct editing of the xml options file but it would be much smarter if you use an editable dropdown box here (so user could pick one of the four values OR key in his/her own value).