To get the latest version of the SQL admin toolset, click here to complete and submit the registration form.

• General
  • This release offers full support for SQL Server 2008.
     
  • Users 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.
     
  • Users 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, users 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, users can browse to servers on different drives.
     
  • A database can be renamed and copied to the same server instance.
     

• Index Analyzer
  • Users 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.
     
  • Users 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.
     
  • Users have the option to turn off the reindexing warning message.
     
  • Users 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
  • Users 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.
     
  • 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, users 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.
     
  • Users have the option to exclude role-level object permissions.
     

• Server Statistics Are Too High
  • The Server Statistics tool now uses time-interval sampling to ensure that statistics reported on a persecond basis are not unexpectedly high.
     
• User Clone Fails to Copy Database Permissions
  • The User Clone tool now correctly copies the user rights and role memberships assigned to a user when you clone the corresponding SQL Server login.
     
• User Clone Fails to Copy Schema Ownership
  • The User Clone tool now will copy the schema object permissions assigned to a user when you clone the corresponding SQL Server login. To enable this option, select the Include database access check box.
     
• Cannot Clone Database User when SQL Server Login Name is Different
  • The User Clone tool now supports cloning a database user whose name is different than the associated SQL Server login.
     
• Cannot Clone Securables (SQL Server 2005 or Later)
  • When attempting to clone a user from an instance running SQL Server 2005 or later, the User Clone tool will now correctly clone the server, endpoint, and login securables associated with the source user.