For the best web experience, please use IE11+, Chrome, Firefox, or Safari

ApexSQL Search release notes

Release:

2022.02.0189

Date:

June 10, 2024

Fixes:

  • The "Failed to login. Internet connec􀆟on is required to con􀆟nue. Click Retry to try again" error is encountered on applica􀆟on start

Changes:

  • Mul􀆟-select op􀆟on to select all databases has been added in the Text Search database dropdown menu

Release:

2022.01.0182

Date:

May 12, 2022

Fixes:

  • 162811: A selected database from Object Explorer is not automatically targeted within Object search controls when a search is initiated from the toolbar
  • 165044: Application default shortcuts under the Options dialog cannot be modified and saved
  • 165047: SQL Server Management Studio stops working when the ellipsis button is clicked from the result grid under the Column value of the Text search pane and the user is connected to a remote server using Azure Active Directory - Integrated authentication
  • 165725: "Unsaved documents cannot be cut or copied to the clipboard from the miscellaneous files project. You must save the unsaved document(s) before cutting or copying them." error message appears when either Ctrl+C or Ctrl+X command is used from the Search text box of the Text search panel
  • 165732: The Text search feature does not find any results when the search string has either leading or trailing whitespace characters in the search phrase
  • 165734: Initiated text search is not cancelled when the Text search pane is closed
  • 172022: Text search feature does not work when invoked against an Azure SQL database and the user does not have access to the master database
  • 186418: Unable to determine which connection is being used to perform either an object or data search from the drop-down list of distinct server names under the Database section
  • 194476: Objects search and Text search features do not work when clicked from the toolbar if no server is previously selected from either SQL Server Object Explorer or Server Explorer in Visual Studio
  • 199489: "Insufficient permissions to access master database" info message is shown when either Object search or Text search is initiated and the user is connected to a remote server using Azure Active Directory - Integrated authentication
  • 200245: Text search feature does not return any results if the search scope has a table with a column of either money or smallmoney data types

Changes:

  • The activation model is switched to Subscription
    • The application does not support integration into SQL Server Management Studio 2012, 2014, and 2016 versions
    • The application does not support integration into Visual Studio 2010, 2012, 2013, and 2015 versions
    • Ignore whitespaces option is added for the Text search feature for easier control of the search scope

    Known issues:

    • "The 'ApexSOLSearchJnstPackage' package did not load correctly" error is encountered when the Visual Studio 2019 16.7 version is started

    Release:

    2021.01.0188

    Date:

    November 02, 2020

    Changes:

    • The application is now part of the ApexSQL Fundamentals Toolkit for SQL Server bundle and requires activation

    Release:

    2020.03.0178

    Date:

    October 08, 2020

    Fixes:

    • 188714: SQL Server Management Studio stops working when the Data search is initiated and then canceled by closing the Text search tab

    Release:

    2020.02.0173

    Date:

    July 30, 2020

    Fixes:

    • "Insufficient permissions to access master database" error is encountered when a connection to an Azure SQL Database is established with the Azure Active Directory - Universal with MFA authentication method and the Object search or Text search feature is used

    Changes:


    Release:

    2020.01.0168

    Date:

    May 28, 2020

    Enhancements:

    Fixes:

    • "Insufficient permissions to access master database" error is encountered when the Object search feature is used on the SQL Server 2008R2 version

    Release:

    2019.03.0153

    Date:

    November 20, 2019

    Fixes:

    • The Safe rename feature does not work when one table has several foreign key relationships
    • The Copy cell command from the right-click context menu in the Object search panel does not work
    • The add-in toolbar stays after uninstall in SQL Server Management Studio 2012 and 2014
    • "Exception has been thrown by the target of an invocation" error is encountered when the Navigate to the Object Explorer node command is used over a user defined function from the right-click context menu in the object search grid result

    Release:

    2019.02.0145

    Date:

    September 19, 2019

    Fixes:

    • Object and Text search tabs are displayed empty within Visual Studio 2019, if the Optimize rendering for screens with different pixels densities option is enabled in the General node of the Options window
    • Visual Studio 2019 stops working when a new query editor is opened
    • Text search does not find any results, if the search word in the Search text box is more than 10 characters long on SQL Server 2016 and earlier
    • The Exact match option under the Text search tab does not work on a database with the case sensitive collation
    • SQL Server Management Studio stops working when the empty Text search grid is double-clicked
    • The application does not integrate into Visual Studio 2017 Community version, even though it was selected during the installation process

    Release:

    2019.01.0139

    Date:

    August 23, 2019

    Enhancements:

    • Search multiple databases simultaneously

    Fixes:

    • Text search filters set in the custom Values tab under the Select objects to search pane are omitted and the whole database is searched instead
    • The add-in does not find all objects that exist in the database when an object with the same name is present in two schemas
    • The add-in does not default to the active database when either Object or Text search is initiated
    • Highlighted text cannot be copied to the clipboard from the object definition view of the object selected in the search
    • Text search doesn't return any results of columns that have the money and smallmoney data types
    • The text search does not find any results of the date column search
    • When the search object body option is selected Synonyms should be searched by base object name
    • Object search does not return any results of functions and schema search which had a similar name
    • The Navigate to object explorer freezes SSMS/VS and does not find the Temporal table (History) in Object Explorer
    • Object reference not set to an instance of an object error message appears when use the Options command from add-in main menu in Visual Studio 2019
    • The context menu has a 3 seconds delay until is displayed when right-click is used on a trigger in Object Explorer

    Known limitations:


    Release:

    2018.09.0127

    Date:

    June 21, 2019

    Changes:


    Release:

    2018.09.0126

    Date:

    May 22, 2019

    Fixes:

    • The add-in doesn't integrate with SQL Server Management Studio 18 GA version if the host application was not started at least once

    Release:

    2018.08.0125

    Date:

    May 04, 2019

    Fixes:

    • The add-in doesn't integrate with SQL Server Management Studio 18 GA version

    Release:

    2018.07.0123

    Date:

    February 04, 2019

    Fixes:

    • The "Connection is not established" message is shown when in Object explorer a SQL Server Analysis Services instance or SQL Server Reporting Services instance connection exist
    • The application installer does not check if the .NET Framework 4.7.2 is installed on the operating system

    Changes:

    • ApexSQL parent menu of the add-in is now located under the Extensions main menu in Visual Studio 2019

    Release:

    2018.06.0120

    Date:

    January 21, 2019

    Enhancements:

    • A toolbar is added to host application with three commands
      • The Object search command opens Object search dialog
      • The Text search command opens Text search dialog
      • The Safe rename command opens the dialog for renaming tables, procedures, views, functions and columns without breaking dependencies
    • A toolbar is added to host application with three commands
    • Object definition column in the results table of the Object search dialog is added
    • Preview window in the results table of the Object search dialog is added

    Fixes:

    • Column filters in the search result table of the Text search dialog do not work properly
    • Incorrect position of the Find button and missing option to check/uncheck all items in the Text search dialog when Windows DPI setting is set to 125% and above
    • Missing Find button and option to check/uncheck all items in the Object search dialog when Windows DPI setting is set to 125% and above
    • Safe rename script is opened within a new query editor tab which is disconnected from the server when the Create script command is used on an object
    • Settings set in the custom Values tab does not apply to settings under the Select objects to search pane of the Text search dialog
    • Table filters under the Select object to search pane of the Text search dialog do not work properly
    • The Check for updates on startup option is not saved when unchecked and the host application is restarted
    • The Object search dialog has multiple issues on high DPI and 4K resolution

    Changes:

    • The application now requires Microsoft .NET Framework 4.7.2

    Release:

    2018.05.0115

    Date:

    December 19, 2018

    Enhancements:

    Fixes:

    • "Error occurred in Safe rename functionality" error is encountered when the Safe rename command is clicked from either Object Explorer or add-in main menu
    • The uninstall confirmation message box appears when the /verysilent option from CLI is used
    • The add-in commands from the context menu under the Object Explorer pane appears when connection to SQL Server Analysis Services instance, SQL Server Reporting Services instance and SQL Server Integration Services instance is established
    • "Search finished successfully. No matches were found for text" message is shown when search performed on contained database
    • "Object reference not set an instance of an object" message is shown in the Database drop down box under the Text search window when listed an offline database

    Release:

    2018.04.0110

    Date:

    November 13, 2018

    Fixes:

    • SQL Server Management Studio stops working after connecting to a SQL Server Analysis Services instance
    • SQL Server Management Studio stops working after connecting to a SQL Server Reporting Services instance
    • The names of the hosts in the host integration step are cutoff on high DPI and 4K resolution
    • The "The ApexSQL Search _Inst Package" package has not loaded correctly "warning message appears when launching SQL Server Management Studio 18 preview

    Release:

    2018.03.0108

    Date:

    October 05, 2018

    Enhancements:


    Release:

    2018.02.0105

    Date:

    September 25, 2018

    Enhancements:

    Fixes:

    • The "Search finished successfully. No matches were found" message is shown when regular expression is used in the Filter row box of the Object search or Text search dialog

    Release:

    2018.01.0100

    Date:

    July 19, 2018

    Enhancements:

    Fixes:

    • The Copy cell command in the context menu under the Text search grid does not copy correct data when the order of the column in the grid is changed
    • SQL Server Management Studio stops working after connecting to a SQL Server Analysis Services instance
    • The Safe rename dialog closes when the object from Azure SQL Database is renamed and the Preview or Create script button is pressed

    Changes:

    • Dependency viewer feature is discontinued
    • The application now requires Microsoft .NET Framework 4.7.1

    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:

    June 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 Server instances
    • 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