SQL admin toolset

download a trialdownload trial


 

What's New in SQL admin toolset version 1.2

New Features

  • 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.

New in Version 1.1.0.65

  • 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.

 

 


 

Copyright | SQL Tools | Legal | Privacy