Softadmin® Assistant (SSMS 22)

Softadmin® Assistant is a SQL Server Management Studio extension that simplifies the workflow when working with Softadmin®.

The latest version can be downloaded at https://softadmin.com/assistant. Requires SSMS 22.3.0 or later.

Features

Open Softadmin® Assistant (Ctrl-J)

Opens the Softadmin® Assistant object explorer that shows objects grouped by schema and name rather than type, with internal Softadmin® objects filtered into separate tree-views.

Open Object in New Tab (F1)

Opens the object under the cursor in a new query tab.

Open Object in Current Tab (Ctrl-F1)

Opens the object under the cursor in the current query tab replacing any text in the tab.

Open Object from Textbox in New Tab (Ctrl-T)

Opens a textbox that can search for objects. Opens the selected object in a new query tab.

Open Object in Browser (F11)

Opens the Softadmin® menu item to edit the object under the cursor when used in the auto comment block. (Available if the Softadmin®-system is version 8.5+).
Opens the documentation website for any public Softadmin® object under the cursor.

Rebind keyboard shortcuts

The keyboard shortcuts mentioned above are the recommended shortcuts and they will be bound on installation if no other shortcuts are bound to the same key combination in the Query editor context. However (Ctrl-T) and (Ctrl-F1) are bound to other actions with the default SSMS installation and need to be bound manually to work.

To rebind a shortcut:

  1. Go to Tools -> Options -> Environment -> Keyboard -> Keyboard
  2. In "Press shortcut key", press the shortcut you want to rebind. For example (Ctrl-T).
  3. Open the dropdown "Shortcut currently used by:", find any shortcut(s) bound in the "SQL Query editor" context. Take note of the name.
  4. In "Search commands containing" search and select the command with the name noted in 3.
  5. In "Shortcuts for selected command" select the key combination that is occupied in the "SQL Query Editor" context. Press "Remove".
  6. Repeat 4 and 5 if more than one shortcut was found.
  7. In "Search commands containing" search for "SoftadminAssistant", and select the command you want to bind a shortcut for. For example SoftadminAssistant.OpenObjectFromTextbox.
  8. In "Use new shortcut in" select "SQL Query Editor". In "Press shortcut keys", press the command you want to bind. For example (Ctrl-T).
  9. Press "assign".

Additional action required

In some cases, the installation may complete with an “Additional action required” message. This occurs when the installer is unable to automatically clear the SSMS cache.

It can be resolved by manually clearing the cache:

  1. Open a Command Prompt window.
  2. Navigate to the directory where the SSMS v22 executable is installed.
  3. Run the following command: start /wait "" ".\SSMS.exe" /updateconfiguration