2018-05-01 (first published: 2018-04-20)
853 reads
2018-05-01 (first published: 2018-04-20)
853 reads
Script that searches every object in a database for a specific string.
2016-06-20 (first published: 2016-05-02)
862 reads
Sometimes, you just want to do a search in a SQL Server database as if you were using a search engine like Google. Besides the obvious Full-Text search, Phil Factor describes some of the techniques for finding that pesky data that resists the normal SELECT blandishments.
2014-05-01
8,755 reads
In this script, we can search a Field and Table in all databases on the server, returning the Field value.
2013-11-15
32 reads
Find all columns containing a string value across all tables and schemas.
2012-11-07 (first published: 2012-10-12)
1,853 reads
Searches database for up to 4 keywords. It will search through SPs, UDFs, Triggers, SSIS packages, jobs, table names, and column names.
2012-05-10 (first published: 2012-04-18)
2,137 reads
Find quickly all stored procedures, tables and views that are somehow related to the search term.
2011-02-09 (first published: 2011-01-28)
2,714 reads
Recently Ben Kubicek created a script that would allow him to copy his production db to a test instance and correct the production specific SQL code in stored procedures and views.
2010-02-03
7,386 reads
2010-02-15 (first published: 2010-01-18)
18,072 reads
This procedure searches for your criteria not only in code, but also in objectnames
2009-11-16 (first published: 2009-10-20)
1,074 reads
I recently received a complaint that Query Store for a particular database was turned...
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
By Steve Jones
I had a customer that was looking to document a restore that had occurred...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers