• Maybe it's just me but I find the combination of the issues below make it unusable.  I have reverted back to SQL2k QA after several thwarted attempts to use Man Studio successfully.  (I am a database developer using SQL 2000)

    You can't change the default scripting options as mentioned earlier in this thread.  QA had the ability to switch on and off DROP object scripts and permissions scripts when you script a CREATE object.  Man Studio won't let you change any options for scripting a single object (from the object browser tree) as far as I can see.  I also don't want the USE statement for every object that I script but you can't turn this off either.  I find myself continually cutting and pasting just to get what you could easily tailor in QA.

    The text editor is now like VS but for me this is just a further annoyance.  If you press Shift + Home QA (and pretty much every other text editor that I've used) will highlight the whole of the current line.  Man Studio "cleverly" highlights from the first character.  Whereas this is useful in VS when there is a lot of indenting it has little or no value (for me) in writing T-SQL.

    If anyone knows how to change this behaviour I'll more than grateful if you can point me in the right direction.