ApexSQL Search release notes

Release: 2013.01.0006
Date: March 18, 2013
Description: Major feature, medium fix release

Enhancements:

  • The add-in now integrates with Visual Studio 2012
  • SQL objects’ extended properties can now be edited visually using the extended property editor
  • Query editor tabs are automatically renamed to reflect their content in order to facilitate navigation between multiple open query editor tabs

Fixes:

  • Mapping/remapping hotkeys requires restarting SQL Server Management Studio
  • Navigation keys do not work for Database object/text search text-boxes
  • The number of found matches is not updated after additional filters are applied
  • The ellipsis button that shows additional information about found matches is missing from the Database text search dialog
  • When an item is selected from the Search object history using the mouse, the saved settings are not applied
  • User defined functions cannot be renamed using the Smart rename refactor in the Database object search results grid context menu
  • The "No items selected. Select at least one column" error is encountered if only columns were selected for the search
  • The initially disabled Numeric columns option in the Database text search cannot be modified when a search is selected from the history
  • Changing the search text while the database text search process is running, returns incorrect results
  • When using Database object search on a read-only database, the "Navigate to Object Explorer node” option tries to find the selected object in a different database
  • The Database object search progress indicator doesn’t show the search progress correctly
  • The add-in can be installed even if no Microsoft Studio instances exist
  • The "At least one of the search options must be selected to initiate text search” error is encountered when only the "Exact match” option is selected in the Database text search
  • The Hotkey for "Find now" in the Database text search changes from "F" to "n" at the end of the search process
  • The RAM memory used by the add-in isn't released after the Search dialog is closed
  • Database text search initialization requires significant time even for small databases, when SQL Server is connected via a slow connection
  • SQL Server Management Studio becomes non-responsive when a filter in the results grid is applied before the Database text search process is completed
  • The add-in initializes the Database text search on all databases, if they were searched in the last session, thus slowing down initialization
  • The ApexSQL Search item exists in the Visual Studio 2010 Server Explorer’s context menu for all of the SQL objects
  • When the add-in is installed, navigating through the databases and tables in the SQL Server Management Studio Object Explorer, on a remote SQL Server connected via VPN, is significantly slower
  • Database text search initialization cannot be canceled
  • The "Exception has been thrown by the target of an invocation.” error is encountered when initiating an object/table search in case the logged user has insufficient permissions on the searched database
  • The Database object search can’t find columns of a user defined type
  • The notification about a changed history item in the Database text search is not fully visible on most screen resolutions
  • When selecting an object to search in the Database text search, its columns are not selected. When the object is unselected, all of its columns are selected
  • "Navigate to Object Explorer node” in the Database object search results grid context menu, doesn’t work for system objects
  • The Database object search doesn't detect system objects properly
  • The add-in can be uninstalled while SQL Server Management Studio is running
  • No warning is shown if SQL Server Management Studio or Visual Studio are running during the add-in uninstallation
  • The "ApexSql.Common.Dependency.ParsingException” error is encountered when opening Visual dependencies for SQL objects
  • The add-in allows defining the same shortcuts for all features in the Options dialog
  • The Help button in the Options dialog doesn’t work
  • At startup, the installer requests to close SQL Server Management Studio
  • The database Dependency viewer window appears in the background, when invoked from the context menu
  • The "Deserialize: There is an error in XML document” error is encountered when invoking search from the Object Explorer
  • The text in the status bar isn't removed when the database text search process is restarted
  • The "Object reference not set to an instance of an object” error is encountered when the grid filter is used
  • The Search icons in the SQL Server Management Studio 2012 Search menu are low quality
  • The View dependencies window can’t be closed pressing the Escape key
  • The error message "The selected object cannot be found. Refresh Object Explorer and try again” is incorrectly displayed when a user with insufficient permissions tries to use the Smart Rename refactor
  • The installer indicates that the installation has been customized although the default settings have been selected
  • The "View the README file” option in the last dialog of the installation process is missing
  • The Script as feature doesn’t exist in this version of the add-in
  • The "Navigate to Object Explorer node” option in the Database object search results grid context menu, doesn’t work for Default objects
  • The Database list contains all databases on the SQL Server instance currently connected to, including the ones the current user cannot access
  • The Defaults command in the Options dialog deselects all check boxes
  • Deselecting a check box in the Options dialog, doesn't disable the corresponding key combination until SQL Server management Studio is restarted
  • The context menu in the SQL Server 2005 SP0 Object Explorer isn’t displayed for columns and parameters
  • There is no notification that the search process is completed, so for fast searches with no matches found, it appears like the search hasn’t been performed
  • The question "Where should ApexSQL Search be installed?” encountered during the installation is excessive
  • The "No items selected. Select at least one column" warning is encountered even when columns are properly selected
  • The "Navigate to Object Explorer node” feature expands the selected object
  • The Visual Studio Server Explorer context menu icons are missing
  • The import/export settings option in the Options dialog is missing
  • The Database text search progress bar disappears after reaching the end, even though the search is still in progress
  • Deselecting all of the search options while the database text search is in progress, prevents canceling it
  • The Smart rename option is enabled in the Database object search results grid context menu for the object types that cannot be renamed
  • Selecting a specific table column from the "Select objects to search” list in the Database text search, doesn't select the parent table automatically
  • The Search icons don’t exist in SQL Server Management Studio 2005 SP0
  • The default options set by the Options Default button are different from the options set during the installation
  • The "Search database objects” returns all database objects when the search text is a blank space character

Release: 2012.01.0004
Date: September 14, 2012
Description: Initial release

Enhancements:

  • Allows searching for text within database objects including object names
  • Allows searching Table and View data
  • Allows fast access to previously searched objects using search history
  • Visualizes all objects’ relationships
  • Changes names and schema of tables, views, stored procedures, functions, columns and parameters without breaking dependencies
  • Identifies interdependencies of all objects including those SQL Server itself fails to process
  • Support encrypted objects
  • Supports Visual Studio 2010, 2008 and 2005
  • Supports SQL Server 2012, 2008 and 2005