When you open up new queries in SSMS they are always called SQLQuery1.sql , SQLQuery2.sql etc. etc.

what would be useful is if SQL prompt generates a more useful filename when you click Save or Save As in SSMS.

For example,

Say I had the script:

CREATE VIEW report.vwRandomName
as
SELECT *
FROM TableA

when I clicked save, it would replace SQLQuery1.sql with

report.vw_RandomName.View.Create.sql

and the same with other object types (table/stored procs etc) and other actions (create / alter / drop).

thanks
ben