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:
- 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
You can now view a list of columns of an index in the order that they were defined.
Patch Analyzer now includes the latest SQL Server service packs.
- Multi Query now correctly sorts the returned results.
- You can now use multi-line strings when performing a query.
The Space Analyzer tool now correctly reports the value for the Maximum Potential Size metric.
1.3 Fixed issues
You can now successfully retrieve job information from a server group that contains duplicate SQL Server instances.
You can now successfully move SQL Server jobs whose names contain single quote marks (').
You can now successfully clear the returned results of your query from the Query Execution and Results pane.
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.
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
- 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.
Windows Authentication field allows a connection test to be run under an alternate user account.
Added a new comparison report.
- 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.
You can select individual or multiple databases before running the Index Analyzer.
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.
Moving jobs with multiple steps no longer causes an error.
Viewing details of a partitioned table no longer generates an error message.
- 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.
Results are sorted by SQL Server name, and can be further sorted by column within each group.
- 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.
- 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.
You can now start, stop, pause, resume, and restart SQL Server instances.
- The server state is now correct for SQL Server 2000.
- The results for per-second counters (e.g. logins/sec) are more accurate.
- 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.
When scanning, you may enter a range of IP addresses or a local subnet.
- 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.