There’s one thing that bugs me to no end in ToadSS. We use a template for our stored procedures that contains try…catch and transaction handling code predefined. It’s set to read only on the file system so people don’t accidentally save with their code. In MS, I can open the file, modify it and save and MS will prompt me to save with a new name or override. In ToadSS I can’t make a change to the file until I go to the file system and change the attribute to read/write. If I do it in Toad or change it while the file is open Toad doesn’t recognize the change. So I have to 1) close the file, 2) go to file system and copy the file to a new name (the name of the sproc I’m creating) 3) change the new file to rw, 4) open the file in Toad. That’s WAY inconvenient to me.
Why do we save our SP’s to a file? Because I require the developers to script every change they make to the database so we can build a rollout for QA and then Production.