Templates and snippets in SSMS turn repeated SQL patterns into editable starting points while keeping environment assumptions visible.
SQL SERVER – 2005 – Open SSMS From Command Prompt – sqlwb.exe Example
Open SSMS from command prompt with the sqlwb command. I show its syntax and the switches I use, like -E and -nosplash, to start Management Studio.
SQL SERVER – Query Analyzer Short Cut to display the text of Stored Procedure
A quick Query Analyzer shortcut: map sp_helptext to a key, select any SP name and display the text of Stored Procedure right in the result window.