You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

 

ApexSQL Search release notes

Release:

2016.07.0080

Date:

December 11, 2017

Fixes:

  • "Microsoft SQL Server Management Studio 17 is not installed. Please install this version to integrate into" message is shown and the add-in installation doesn’t continue when SQL Server Management Studio 17.4 is installed
  • SQL Server Management Studio 17 stops working when the View dependencies command is used from the Object Explorer context menu or from the application main menu
  • Visual Studio 2017 stops working after the add-in is uninstalled
  • The "Date columns" option in the Text search window does not work

Release:

2016.06.0072

Date:

Jun 19, 2017

Fixes:

  • "Could not find server 'PNGBRANCH_FOR_APEX' in sys.servers" error is encountered when renaming a specific column referenced in stored procedures
  • The Exact match option under the Database text search does not return valid data
  • “Comparing ntext and varchar datatypes failed” error is encountered in the Text search dialog under the Database text search when the ntext and varchar datatype are used
  • The Text search dialog under the Database text search does not appear when for the first time is initiated
  • The Save dialog does not appear in SQL Server Management Studio when a sql file in an SSDT project is closed in SQL Server Management Studio
  • The previously installed add-in version is not removed when the default installation path is changed during the installation
  • The add-in installation will automatically overwrite previously installed add-in version
  • The list of objects is not shown from the top under the Database object search when a database object search is finished

Release:

2016.05.0070

Date:

May 22, 2017

Enhancements:

  • SQL Server 2017 CTP 2 support

Fixes:

  • Changing SQL server instance connection from the Server dropdown under the Database object search and Database text search dialogs does not work
  • "Connection is not established" warning message is encountered when the Database object search or Database text search are used for the first time

Release:

2016.04.0065

Date:

December 12, 2016

Enhancements:

  • Visual Studio 2017 RC integration
  • SQL Server Management Studio v17.0 RC1 integration

Release:

2016.03.0059

Date:

October 17, 2016

Fixes:

  • "The following feature couldn't be installed .NET Framework 3.5 (includes .NET 2.0 and 3.0)" message occurs when installing the add-in in Windows 8 and Windows 10 OS
  • The context menu needs too much time to appear on the right click in the Object Explorer pane
  • ApexSQL Search is not shown in ApexSQL main menu under SQL Server Management Studio 2016

Release:

2016.02.0052

Date:

August 19, 2016

Enhancements:

  • Visual Studio 2015 integration
  • Visual Studio 15 Preview 4 integration

Changes:

  • Deprecated support for SQL Server Management Studio versions prior to 2012
  • Deprecated support for Visual Studio versions prior to 2010

Release:

2016.01.0031

Date:

June 03, 2016

Enhancements:

  • Support for SQL Server 2016
  • SQL Server Management Studio 2016 integration

Release:

2014.06.0028

Date:

September 04, 2015

Fixes:

  • No search features will work, if the Cumulative update 7 for SQL Server 2012 Service pack 2 is installed
  • "Could not load file or assembly" error is encountered when double-clicking search results in order to navigate to the specific object in the Object Explorer for SQL Server Management Studio 2014
  • SQL Server Management Studio and Visual Studio loads slower after installing the add-in

Release:

2014.05.0025

Date:

June 03, 2015

Fixes:

  • The "Database object search" feature reports a "sys" system schema as an object of XML schema collection type
  • SQL Server Management Studio goes out of focus when closing the "Dependency viewer" window and the "Dependency viewer" Options windows
  • The add-in causes SQL Server Management Studio to stop responding, when initiating the "Database object search" feature, in case when the user is allowed to search just in the system databases
  • The "Navigate to object explorer node" function is not working on any objects in SQL Server Management Studio 2008
  • The "Rename queries automatically" option is not working for SQL Server Management Studio 2012 and 2014
  • Missing an option to cancel the current changes when the "Do you want to save changes" message is shown in the "Edit extended properties"
  • Zooming out the "Dependency viewer" to less than 12% causes SQL Server Management Studio to stop responding
  • A list of database objects is not refreshed when the "Database text search" is initiated from the history
  • The "Type filter" shows excessive results for schemas
  • The "Type filter" shows excessive results for trigger
  • The "Type filter" shows excessive results for user
  • The list for the Schema filter is not sorted alphabetically
  • The Expand/Collapse buttons in the "Edit extended properties" window do not affect child objects
  • The "Filter" button in the "Edit extended properties" window completely disables all filtering
  • Initiating help from the "Database text search" window closes the window
  • Two consecutive warning messages are shown, if the "Safe rename" for incorrect object is initiated
  • The default location for add-in files is changed after a specific Windows update
  • The maximize button closes the "Dependency viewer" window
  • The object selection cannot be saved inside the "Dependency viewer"
  • "Not found database with name 'database name'" error is encountered when initiating the "View dependencies" option from Visual Studio 2013
  • There is no the "Save results as" option for the "Database text search" feature
  • The progress bar in the "Database text search" feature remains when the focus is changed to another window and the search is finished with the "Nothing was found" message

Release:

2014.04.0024

Date:

March 17, 2015

Enhancements:

  • The add-in now supports Azure SQL Database V12
  • The user interface of the "Dependency viewer" feature was redesigned and improved

Known issues:

  • The "Navigate to object explorer node" feature does not work in SQL Server Management Studio 2008

Release:

2014.03.0023

Date:

January 21, 2015

Fixes:

  • The "Server Explorer doesn't contain nodes for Procedure objects" error is encountered when initiating the "Navigate to server explorer node" option from the "Database object search" feature in Visual Studio 2012
  • The "The visual dependency viewer cannot be used for the selected node. Select a database or object" error is encountered when initiating the "View dependency" feature in case Server Explorer view is set to the "Schema" layout
  • The default location of the add-in exported options file is incorrect
  • A connection to the server cannot be established/changed from the "Database text search" tab
  • A connection to the server cannot be established/changed from the "Database object search" tab
  • An exception is encountered when connecting to SQL Server 2000 or SQL Azure
  • The "No item was found matching name 'Server Explorer'" error is encountered when starting Visual Studio if Object Explorer is not enabled
  • Both, table and its related columns are not checked automatically when initiating the "Database text search" feature in case Server Explorer view is set to the "Object type" layout
  • The add-in fails to navigate to object in Object Explorer if the object is not from "dbo" schema in Visual Studio
  • The "Send logs" button does not open the log file location, if there is no e-mail client installed on the system
  • The "Database object search" feature does not properly detect system objects
  • The "Database text search" option for the system database must be refreshed to pass initialization in order to start it
  • The "ApexSql.Common.Dependency.InvalidArgumentException" error is encountered when initiating the "View dependencies" feature in Visual Studio
  • The "Object name" option is duplicated in the "Found in" column of the Filter row
  • The same add-in shortcuts can be specified
  • The "Object reference not set to an instant of an object" error is encountered when the Object Explorer is disconnected and the "Navigate to object explorer node" option is initiated from the Results grid
  • The F1 key does not initiate help in the "Edit extended properties" dialog
  • Filter selection disappears when applying filter in the "Edit extended properties" feature
  • The "Navigate to object explorer node" option is not working on SQL procedure's output parameters
  • The "Depth" option in the "View dependencies" feature does not work
  • The "Send logs" button opens a new email window which stays on top, and does not allow switching to another application
  • The "Object reference not set to an instance of an object" error is encountered when the "Database text search" window is closed while loading all databases
  • The "Hide object" option in the "View dependencies" feature does not work correctly
  • The "Row filter" in the "Database text search" feature does not show an empty list when filtering something that doesn't exist
  • The add-in cannot find columns with empty strings using the "Database text search" feature
  • The "Description" filter in the "Extended properties editor" feature is empty
  • The link to the add-in help page is incorrect
  • The "Object filter" option is not filtering out objects correctly in the "Database text search" tab
  • The "The parameter is incorrect" error is encountered when restoring add-in options to default in Visual Studio 2012/2013
  • The "Cannot open database "database_name" requested by the login. The login failed." error is encountered when initiating view dependencies feature
  • The "Cannot open database "database_name" requested by the login. The login failed." error is encountered when initiating extended property editor
  • The add-in causes the conflict issue with another add-in options
  • The "Safe rename" feature does not work when initiated from the Results grid, in the "Database text search" tab, for user tables, user functions, and procedures

Known issues:

  • The "Navigate to object explorer node" feature does not work in SQL Server Management Studio 2008

Release:

2014.02.0021

Date:

October 3, 2014

Enhancements:

  • The add-in now fully supports SQL Azure

Fixes:

  • Only one server connection is registered when using the "Object search" feature, if the user disconnects from one server and remains connected to multiple SQL servers
  • The "Copy to clipboard as HTML" option from context menu does not work
  • The database drop down list contains databases the currently connected user does not have an access to
  • The next button in the installation wizard is grayed out when installing and integrating a new version in SQL Server Management Studio, if an older version is already installed
  • Databases are not sorted by name in the database drop down list, when using the "Database object search" feature
  • When the "Database object search" feature is initiated, it is not possible to connect to different SQL Server via SQL Server Management Studio 2012
  • The "Results grid" section becomes empty when filtering results by the "Preview" column and entering a non-existing condition
  • The "Unable to cast object of type 'Microsoft.SqlServer.Management.Common.SqlConnectionInfoWithConnection'" error is encountered when the "Navigate to object explorer node" option is used with Object Explorer disconnected
  • The "Database object search" result grid scrolling has a delay when contains a large number of rows
  • Missing an informative message when renaming a table in a specific case
  • The "Navigate to object explorer node" option will not navigate to a proper object, when initiated from the "Database object search" results grid
  • The "Navigate to object explorer node" option is not working on SQL user table objects
  • The "Navigate to object explorer node" option is not working on SQL stored procedure objects
  • The "Navigate to object explorer node" option is not working on SQL message type objects
  • The "Navigate to object explorer node" option is not working on SQL full text catalog objects
  • The "Navigate to object explorer node" option is not working on SQL function objects
  • The "Navigate to object explorer node" option is not working on SQL default objects
  • The "Navigate to object explorer node" option is not working on SQL triggers found in object body
  • The progress bar is always visible when using the "Database object search" feature
  • The add-in installer does not detect the previous version of the add-in
  • The "Check/Uncheck all" option is missing when using the "Database object search" feature
  • The default folder for saving database object search results in Visual Studio is not correct
  • The row filter is disregarded when the "Database text search" feature is used and the filter remains
  • The numbers can be assigned to add-in shortcuts, although they will not be usable and visible in the add-in menu
  • The "No matches were found for text <text_to_search>" message is encountered when a search is performed for SQL XML schema collection data type and nothing is shown in the results grid
  • The "Visual dependencies" viewer is empty when the "Visual dependencies" option is initiated from the "Database object search" results grid
  • The progress bar is not the same in the "Database object search" and in the "Database text search" features
  • The search history is inconsistent in the "Database object search" and in the "Database text search" features
  • The "The Object Explorer doesn't contain nodes for Table objects" error is encountered when navigating to already deleted a table in Object Explorer
  • The current database from the drop down list changes when left-click on any object in the results grid, if a search is initiated with the ENTER key
  • The "Object details" dialog in the "Database text search" feature cannot be closed with the ESC key
  • The "An error occurred in the regular expression in the column Preview parsing" error is encountered when filtering results by preview, in the "Database object search" feature
  • The number of total items found does not include all found items when using the "Database text search" feature
  • The "Export/Import" options are not working correctly in the "Dependency viewer" options
  • The database drop down list remains locked to a certain database, when initiating the "Database object search" feature for that database
  • The "Help" button in the "Edit extended properties" window leads to a help page of another add-in
  • The "Object details" dialog in the "Database text search" feature closes when the "?" button is clicked
  • The "Database object search" feature fails to cannot to multiple SQL Servers
  • The add-in fails to forbid third party tools from integrating into the ApexSQL menu in SQL Server Management Studio
  • The "Database object search" feature does not work when all columns for one table are checked
  • The "Database object search" feature is not working when selecting one of the history searches
  • The database drop down list is not alphabetically sorted in the "Database object search" and in the "Database text search" features
  • The add-in is not present in the ApexSQL main menu in Visual Studio 2010 shell
  • The database drop down list does not allow keyboard letters navigation in the "Database text search" feature
  • The "Search finished successfully. No matches were found for text <text_to_search>" message is displayed when canceling the search process
  • Search history will not be saved, if search is initiated in multiple queries at the same time
  • The "The Object Explorer doesn't contain nodes for Procedure objects" error is encountered and the add-in cannot search from Object Explorer if SQL Server Management Studio is localized to non-English language
  • The "Exception has been thrown by the target of an invocation" error is encountered when a search is performed on SQL Server 2000 database
  • When switching from SQL Azure database to SQL Server database, or vice versa, the objects list in the results grid shows the objects from a previous connection
  • The "Children only", "Descendants", "Parents and Children only", "Parents and Descendants" options are not working correctly in the "Dependency viewer" window
  • The "Extended property editor" feature closes when trying to initiate various commands

Known issues:

  • The "Navigate to object explorer node" feature does not work in SQL Server Management Studio 2008

Release:

2014.01.0017

Date:

May 14, 2014

Enhancements:

  • The add-in now fully supports SQL Server 2014

Fixes:

  • Text within stored procedures is not included in search when only stored procedures are selected for search
  • Incomplete dependencies are listed when using the "View Dependencies" option on Views

Changes:

  • New user interface that follows Metro UI style

Release:

2013.04.0012

Date:

November 19, 2013

Enhancements:

  • The add-in now integrates with Visual Studio 2013

Fixes:

  • The Search Options dialog is missing 'ApexSQL' in it's name
  • The application features are not correctly named in the Search Options dialog
  • Text within triggers is not included in search even when triggers are selected for search
  • The object selection setting is not remembered in the search history
  • The 'Unhandled exception - Conversion overflows' error in .NET framework is encountered when invoking row details after changing database selection
  • The 'The data types ntext and varchar are incompatible in the equal to operator.' error in .NET framework is encountered when investigating row details on 'nchar' or 'varchar' columns with punctuation values

Release:

2013.03.0010

Date:

September 19, 2013

Fixes:

  • The "Value does not fall within the expected range: Microsoft.VisualStudio.CommandBars" error is encountered when SSMS or Visual Studio starts with the add-in installed
  • The View dependencies feature requests licensing for the third-party Craniate ERM Diagram feature
  • The "Parse error: Parse error: Error : [Incorrect syntax near '{*}']" error is encountered when starting the Dependency viewer feature
  • The "System.NullReferenceException - Object reference not set to an instance of an object." error is encountered if no node is selected in the Object Explorer pane when initiating 'Edit extended properties' or 'View dependencies' commands

Release:

2013.02.0008

Date:

June 28, 2013

Fixes:

  • Slow startup time for Visual Studio and SQL Server Management Studio instances

Changes:

  • The add-in menu is now under the "ApexSQL" parent menu

Release:

2013.01.0006

Date:

March 18, 2013

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

Features:

  • 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