This build of SQL Admin Toolset includes many fixed issues, including the following updates.

1.6 New features

SQL Server 2012 support

The tools available in the SQL Admin Toolset now support SQL Server 2012.

1.5 New features

New Linked Server Copy tool

The new Linked Server Copy tool lets you quickly and easily copy our Linked Servers from one SQL Server instance to another along with the associated settings, logins, passwords, and permissions.

New options for the Quick Re-Index tool

The Quick Re-Index tool now allows you to:

1.5 Fixed issues

Index Analyzer

You can now view a list of columns of an index in the order that they were defined.

Patch Analyzer

Patch Analyzer now includes the latest SQL Server service packs.

Multi Query

Space Analyzer

The Space Analyzer tool now correctly reports the value for the Maximum Potential Size metric.

1.3 Fixed issues

Job Editor

You can now successfully retrieve job information from a server group that contains duplicate SQL Server instances.

Job Mover

You can now successfully move SQL Server jobs whose names contain single quote marks (').

Multi Query

You can now successfully clear the returned results of your query from the Query Execution and Results pane.

Server Groups

Special characters are no longer supported when naming new SQL Server groups. Support does continue for existing server groups which were created by SQL Admin Toolset version 1.2 or earlier, that contain special characters.

SQL Search

You can successfully search for text strings in a SQL Server job even if the MSDB system database is not listed in your search criteria.

1.2 Fixed issues


Connection Check

Windows Authentication field allows a connection test to be run under an alternate user account.

Database Configuration

Added a new comparison report.

Database Mover

Index Analyzer

You can select individual or multiple databases before running the Index Analyzer.

Inventory Reporter

Server Inventory now includes fields for: TCP Port Setting, Memory Allocation Type, Minimum SQL Server Memory, Maximum SQL Server Memory, Allocated CPU Count, Allocated CPU Count I/O, Number of Physical Processors, Number of Logical Processors, and a list of enabled SQL Server Network Libraries.

Job Mover

Moving jobs with multiple steps no longer causes an error.

Partition Generator

Viewing details of a partitioned table no longer generates an error message.

Password Checker

Patch Analyzer

Results are sorted by SQL Server name, and can be further sorted by column within each group.

Quick Reindex

Server Configuration

Server Ping

You can now start, stop, pause, resume, and restart SQL Server instances.

Server Statistics

Space Analyzer

SQL Discovery

When scanning, you may enter a range of IP addresses or a local subnet.

User Clone


SQL Admin Toolset delivers 24 essential administration tools. Learn more > >
Idera WebsiteProductsPurchaseSupportResourcesCommunityAbout Us  Legal