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

1.7 New features

There are no new features in this release.

1.7 Fixed issues

Backup Status tool

This release corrects an issue causing the Backup Status tool to unnecessarily increase memory consumption.

SQL Search tool

This release corrects an issue causing the SQL Search tool to include excerpts that did not contain the search string.

SQL Discovery tool

• The SQL Discovery tool now displays only a single error message when a user scans a list of computers and one or more of the servers is unreachable.
• The SQL discovery tool no longer crashes when opened in a Windows 7 or Windows 2008 R2 environment.

Connection Check tool

The Server Health Check function of the Connection Check tool now properly connects with SQL Server authentication credentials.

Multi Query tool

This release fixes a possible handle leak in the Multi Query tool.

Database Mover tool

This release corrects an issue causing the Database Mover tool to lock when copying a large database.

User Clone tool

The User Clone tool now properly clones explicit permissions for a database.

Job Mover tool

This release corrects an issue preventing the Job Mover tool from copying the job output file settings.

Quick Reindex tool

• Users who run an edition of SQL Server that supports online index rebuilding now can use that feature in the Quick Reindex tool.
• The Quick Reindex tool now includes the Fill Factor column in the SQL Server 2000 version.
• If you want to rebuild multiple indexes with varying fill factor settings, the Quick Reindex tool allows you to retain the current setting of each index by selecting the Current Fill Factor option in the Index Settings area. Note that the index list also includes the Fill Factor column for you to quickly view the fill factor settings of each index.
• This release corrects an issue causing the Quick Reindex tool to use the old Fill Factor entry when the entry is manually changed on the back end without first loading the index statistics.
• This release corrects an issue causing the Quick Reindex tool to display an incorrect fragmentation percentage.

Partition Generator tool

The Partition Generator tool no longer displays an error message when a user attempts to use the tool on servers running SQL Server 2008 R2 Data Center Edition.

Inventory Reporter tool

• This release corrects an issue causing the Inventory Reporter tool to show an exception error when you have the Show Servers as Rows option turned on, and then click Copy.
• This release corrects an issue causing the Inventory Reporter tool to switch the results of the Minimum SQL Server Memory and Maximum SQL Server Memory columns.

Index Analyzer tool

• The Index Analyzer tool now properly displays the Fill Factor column to display statistics for analyzed indexes.
• This release corrects an issue causing the Index Analyzer tool to show an exception error when you type an alphabetic character into the Hide Indexes under X rows field.
• Corrected an issue preventing the proper function of the Hide Non-Clustered Indexes check box.
• The Index Analyzer tool now displays an accurate Selectivity percentage and the correct total number of records displayed.

Space Analyzer tool

The new Auto Unit field in the Space Analyzer tool allows you to select the unit of measurement that best displays your results.

Server Statistics tool

The Server Statistics tool now returns all the correct data when connected to a SQL server 2012 database.

Server Ping tool

This release corrects an issue causing the Server Ping tool to show an exception to SQL Server 2000 Enterprise Manager users with a local server.

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:

• Specify which fill factor you want to use when the selected index is rebuilt.
• Enable online processing during rebuild.
• Use the Maxdrop setting to specify he maximum degree of parallelism to use during the rebuild.

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

• Multi Query now correctly sorts the returned results.
• You can now use multi-line strings when performing a 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

General

• This release offers full support for SQL Server 2008.
• You may now browse and select databases on a single server. Multiple databases on server groups must be added manually.
• All server browse lists include any servers defined in server groups.
• You can copy error reports to the clipboard.

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

• Database Mover now supports database clusters.
• When moving a database, you have the option to set the default database for all of the migrated users to be the matching databases on the destination server.
• When a database is moved, the database owner is also copied to the destination server.
• When selecting a destination, you can browse to servers on different drives.
• A database can be renamed and copied to the same server instance.

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

• Results can be exported as a TXT, CSV, or XML file.
• Results show the servers tested, the number of logins tested, bad passwords, blank passwords, and passwords that match the login.
• Additional password dictionaries have been added to the default list.
• You may select multiple dictionaries to use simultaneously.

Patch Analyzer

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

Quick Reindex

• The index results are no longer automatically resorted after reindexing.
• You have the option to turn off the reindexing warning message.
• You can select individual databases before loading index statistics.

Server Configuration

• Configuration information now includes service pack level, server collation, and login audit information.
• Comparison results now display differences in server collation values. These differences cannot be updated.

Server Ping

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

Server Statistics

• The server state is now correct for SQL Server 2000.
• The results for per-second counters (e.g. logins/sec) are more accurate.

Space Analyzer

• The Space Analyzer tool now has the ability to display space information for local mount points. However, it only detects mount points on Windows 2003, 2008, and Vista, and the mount point must host a valid database.
• Results now include system databases (e.g. tempdb, msdb).
• Results include a new column % Disk Used by Database File showing how much disk space is used by the selected file.

SQL Discovery

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

User Clone

• The Default Database field for a new user correctly displays databases from the destination SQL Server.
• Source User displays all Windows authenticated group logins.
• You have the option to exclude role-level object permissions.

SQL Admin Toolset delivers 24 essential administration tools. Learn more > >