SSMS Tools Pack is a Microsoft SQL Server Management Studio (SSMS) add-in that dramatically increases your productivity with well-integrated, easy to use features.

1. How To Install Ssms Tools Pack
2. Ssms Tools Pack
3. Ssms Tools Pack License
4. Ssms Download

Features:

Clarification: SQL Server Management Studio's have no official addon support, but there are some tools out there. SSMS Tools Pack is one that I've been very fond of (2005, 2008 versions), but the licensing fee for 2012 is horrible. (I would pay for a reasonable license, but that's not the question here.). This collection of content presents an overview of free SQL Server Management Studio (SSMS) add-ins, with product page links for each of the tools and screenshots if available. SSMS add-ins are presented in alphabetical order. If you noticed a free tool we missed, please let us know in the comments below. ApexSQL Compare ApexSQL Complete. SSMS Tools Pack 5.0.0.0 FOR SSMS 18Tab Sessions make your work with tabs even easier. Each tab is saved periodically as defined by the interval for Window Content History. The two features are connected. You can also Restore Last Session by pressing the button on toolbar. This openes the last saved. SSMS Tools Pack update that fixes the SSMS crashing bug if SSMS is idle for more than 10 minutes. Also a 'Show/Hide Execution Plan Analyzer' button has been added to the toolbar. SSMS Tools Pack 2.0.1 is out. SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases.

Connection Coloring Color the query windows and Object Explorer based on the server/database name or a regex.
SQL Editor Plus Editor improvements like Run Script at Cursor Location and Accidental Data Destruction Protector.
Export To Excel Export result sets, one or multiple tables or the whole database to Excel files.
Format SQL Uppercase, lowercase, propercase and end your SQL scripts with semicolons.
SQL History Keeps your query or window history safe in local files or database.
SQL Snippets Keep your favorite statements accessible with a shortcut of your choice.
Search Databases, Tables, Views data Search through data in single or multiple databases, tables and views with great filtering capabilites.
Execution Plan Analyzer Analyzes the execution plan and suggests possible improvements.
Run script on multiple targets Run a single script on multiple databases on the same server.
Global Replacement Texts Add custom replacement texts to your scripts in four different features.
New query template Modifies New Query windows with a template of your choice.
Copy execution plan to clipboard/file Copy one or all execution plans to the clipboard or to a file.
Search Results in Grid Mode Search through your query's results sets.
Insert statement generator Generate insert statement for result sets, a table or the whole database.
Regions and Debug sections Add regions and/or debug sections to your code.
Run custom scripts from Object Explorer Run custom scripts from a chosen node in Object Explorer.
CRUD stored procedure generation Quickly generate CRUD stored procedures for the whole database or a single table.
Other minor features Minor features that don't go into any main category. that dramatically increases your productivity with well-integrated, easy to use features.
Licensing applies only to SSMS 2012 and higher versions.

New functionality in 5.0.0.0:

Beta support for SSMS 18 Beta support for SSMS 18 preview releases.
Any reported issues will be fixed in the next version.
Manage License Activations Manage license details and number of activated machines.
Great in case of forgetting to deactivate an old machine.
Features Needing Database Caching New: Finer database cache content control. Added support for removing all or some database schemas from cache.
New: Filter databases to load into cache. Specify any direct comparison filter or regex filter on server and/or database names. Matched filter entries are not loaded into database cache.
Insert Statements Generator New: Full culture independent date formatting. All dates can now be formatted with the current culture or a culture independent option.
New: Script grid results to clipboard in addition to scripting them into an editor window.

New functionality in 5.2.0.0: Full support for SSMS 18 SSMS 18 is now fully supported as all reported issues with it have been resolved. SQL Editor Plus New: Rename Tabs has the option to rename current or all tabs to an object name in the first CREATE/ALTER statement in each open query window.
New: Run Statement At Cursor Location has the option to not select the executing query which makes the caret stay in the same position as before. SQL History New: Added exclusion keyword to not save a query in SQL history. The keyword is a preset comment and has to be at the start of the executing selection. Search Grid Results New: Added searching for columns names in grid results.

DOWNLOAD NOW !

SSMS Tools Pack 5.4.1.0 FOR SSMS 18

Tab Sessions make your work with tabs even easier. Each tab is saved periodically as defined by the interval for Window Content History. The two features are connected. You can also Restore Last Session by pressing the button on toolbar. This openes the last saved tabs already connected to the server they were connected too before. Simple, easy and fast.
Window Content History saves the whole text in all opened SQL windows every N minutes. The default being 1 minute. This feature fixes the shorcoming of the Query Execution History which is saved only when the query is run. If you're working on a large script and never execute it the existing Query Execution History wouldn't save it. By contrast the Window Content History saves everything in a .sql file so you can even open it in your SSMS. The Query Execution History and Window Content History files are correlated by the same directory and file name so when you search through the Query Execution History you get to see the whole saved Window Content History for that query. It is turned ON by default.

How To Install Ssms Tools Pack

Query Execution History logs every SQL statement that you run in a file on your disk or in a table in a database you specify with a connection string. This way, if you're working on some script you can get the full history of every change you've made. SQL Statements are saved in a list that is written to a file and/or a database with a timer which you can set to a desired interval. Older query history logs can be auto deleted. Time after which the logs are deleted is user settable. The size of the code to be saved can also be set up to the maximum of 5 MB of code.
Current window history is a dockable window that shows queries executed in a currently active window. It alse has a search box at the top that filters results as you type. Each entry also shows the color of the server/database it was run on. This is very helpful if you change your connection in the same query window.
Global Replacement Texts is a feature that lets you put custom keys, which are then replaced by their defined values, in following features: SQL Snippets, CRUD Generator, Run Custom Scripts and New Query Template. All keys have to be surrounded by pipe characters like so: |ReplacementKey|. There are 4 predefined replacements that you can use: |CurrentDateInYMD|, |CurrentTime|, |CurrentWinUserName| and |CurrentSQLUserName|. You can add as many custom ones as you wish. There's also an advanced option where you can set your key's value to be T-SQL script that will execute and replace the key with the value in the first row and column in the returned result set. All T-SQL statements are run under READ UNCOMMITTED isolation level. They are run with the contextually current active connection in SSMS. If there's an error the returned replacement value will say the error happened.
SQL Editor Plus (available only in SSMS 2012 and up) extendes the editor with the following options:
Rename Tab by right-clicking the window tab or pressing Ctrl+K, Ctrl+R in your query window.
If you're tired of long query names like 'SQLQuery1.sql - LongTextHere',
then simply rename it to whatever you wish. The rename will only apply to the visible window text and not to the underlying filename, tooltip or SQL History saving window caption.
This one can be a real life saver.
It's called the Accidental Data Destruction Protector.
It pops an 'Are you sure?' window if it detects you've executed a DELETE or UPDATE statements without a WHERE clause, a TRUNCATE statement or a DROP TABLE statement. If you're sure you want to proceed just press Enter, F5 or Ctrl+E to continue execution. By default it checks for all four destructive statements only if you're executing a selected text. All of this can be set in Options.
Feature: SQL Snippets
SQL Snippets give you the ability to type shortcuts in editor which after pressing Enter or Tab turn into a predefined code block. You can have as many SQL snippets as you wish.
Since version 1.8 snippets can be exported and imported by themselves.
Since version 1.9 snippets can be saved to html or printed out directly.
Since version 2.7 You can also use {C} where you want your cursor to be after the snippet has been expanded.
Copy selected or all execution plans to a bitmap that is saved either the clipboard or to a file. Large execution plans that don't fit in the window are also copied in full. Width of a picture containing all execution plans is equal to the width of the widest execution plan.
Uppercase/Lowercase keywords and proper case Database Object Names. Set all keywords to uppercase or lowercase letters. Custom keywords can be added. Format all database objects to their proper case sensitive name. You can also end every statement with a semicolon (;) since this is the new standard.
Find all occurrences of your search string in the results in datagrid mode. You can also search only in specific grid columns by preselecting a cell in each column you wish to search in.Multiple cell selecting is done with Ctrl + Left mouse click. Cells that contain found values are visibly colored.

Ssms Tools Pack

New functionality in 5.4.1.0:
SSMS 18 support
SSMS 18 is fully supported. Please report any issue you might run into.
Connection Coloring
New: SQL Editor's Tab Color will move left-right while a query is executing
providing an instant visual cue if anything is running a tab.
Export To Excel

Ssms Tools Pack License

New: Export selected cells from grid results.
New: Export grid results into multiple sheets (grid per sheet).
SQL Editor Plus
Improved: Added connection color, server and database name to the Accidental Data Destruction Protector warning window.
Improved: Rename tab to first object name in the script can now be set as object name only or schema name and object name.
Current version works in:
SSMS 18, SSMS 17,
SSMS 2016, SSMS 2014, SSMS 2012,
SSMS 2008 R2, SSMS 2008

Ssms Download

Only for V.I.P