I use SSMS Query files (.sql) to manage many aspects of a SQL database. Usually, I select portions of the script and click the Execute button to run the selected SQL code.

My problem is sometimes I can accidentally click the Execute button without first making a selection. SSMS attempts to execute the entire script. This can be potentially damaging to the database...

In most cases, I have some SQL code that does SSMS complains about, hopefully before any of the statements are executed, but in others I have "clean" SQL code in the query file, but only wish to execute small portions at a time.

Any suggestions would be appreciated.