Products
Server management
ApexSQL Log
Audit, undo or replay SQL database changes
ApexSQL Recover
Recover deleted, dropped, corrupted or lost data
ApexSQL Restore
Work with backups just like with live databases
Programmable APIs
ApexSQL Diff API
Compare and synchronize SQL databases programmatically
ApexSQL Log API
Audit SQL database changes programmatically
Database development
ApexSQL Audit
Track data changes to SQL databases
ApexSQL Build
Build, update and deploy SQL databases
ApexSQL Clean
Analyze dependencies and remove unused objects
ApexSQL Data Diff
Compare and synchronize SQL database data
ApexSQL Diff
Compare and synchronize SQL database objects
ApexSQL Doc
Document SQL instances, databases and SSIS packages
ApexSQL Script
Script and package SQL databases
Productivity Add-ins
ApexSQL Complete
Auto-complete and coding productivity features
ApexSQL Refactor
Format and refactor SQL code
ApexSQL Profile
Performance profile SQL code
ApexSQL Search
Search SQL objects and data and visualize dependencies
ApexSQL Version
Database version control integration
Value bundles
ApexSQL Change Management Studio
Save
60%
on a complete database change management toolkit
ApexSQL Developer Studio
Save
70%
on all ApexSQL
developer tools and productivity add-ins
ApexSQL Universal Studio
Save
80%
on all ApexSQL
tools in a single bundle
Download
Purchase
Support
Support center
Get started with ApexSQL support
Support forum
Get help directly from staff and peers
Support FAQs
Answers to common questions
Troubleshooting
Known issues and workarounds
Knowledgebase
How-to articles, tips and suggestions
Documentation
Online and downloadable help files
Product videos
Videos for intro, what's new and special topics
Getting started
Articles and videos to get you started with our tools
News
Blog
Get the latest on new releases, updates, promotions
What's new
Information on all new product releases and updates
What's next
A roadmap of upcoming releases and updates
Newsletter
The latest news via email
Press releases
Newsworthy company and product release information
Product updates
Alerts on all product releases including subscription
Company
Why ApexSQL?
Find out what makes us different and better
Jobs
Become a part of the ApexSQL team
Gear
Merchandise for user groups and promotions
Contact us
Contact sales or support by email or phone
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