Fast way to open objects (stored procedure) sql create definition
Shortcut (Shift+Alt+O) to open an window with the names of all database objects (stored procedures, tables) and a textbox to enter the name (partial, multipart) of the object to find. While typing remove non matched names from the list. When selecting an object open a menu with options like Script Object AS (CREATE, INSERT etc).
Then open a new SQL Server Management Studio window with the selected SQL code.
1
vote
Anonymous
shared this idea