ApexSQL Search analyzes SQL Server database object's dependencies within the database, across databases, scripts and even applications. It recognizes all database dependencies, even those not recognized by SQL Server itself. Search for SQL objects directly in SSMS and VS, quickly find data in SQL tables and views, visualize complex relationships between objects, and rename SQL objects without breaking dependencies.
Features: 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. SQL Server 2014 support: Search for objects or text directly in SQL Server 2014 Management Studio including FileTables, sequences and search property lists. Smart rename SQL Server 2014 objects including FileTables. Object search: Search for objects or text in database object definitions. Text search: Search for text, numbers, dates and unique identifiers in your tables and views. Graphical dependencies: Visualize even the most complex relationships between SQL objects. Smart rename: Rename tables, procedures, views, functions and columns without breaking dependencies. Search history: Quickly access previously searched objects with automatically saved searches. Accurate analysis: Recognize all object interdependencies; even the ones SQL Server itself fails to identify. Customizable searches: Specify the object types to be searched. Quick navigation: Navigate to the found object in a single click. Results browsing: Group, sort and filter search results. Transparent description: Search, rename or identify encrypted objects dependencies. Search for data in encrypted views. Visual Studio integration: Supports Visual Studio 2013, 2012, 2010, 2008 and 2005. Support for all SQL Server versions: Full support for SQL Server 2014, 2012, 2008 R2, 2008 and 2005 objects and data.
MSSQL Server 2014, 2012, 2008, 2005, .NET 3.5 Run Time, Microsoft Visual Studio 2005 and above