2018-05-01 (first published: 2018-04-20)
724 reads
Search
Script to Find String in Database object
Script that searches every object in a database for a specific string.
2016-06-20 (first published: 2016-05-02)
842 reads
Searching for Strings in SQL Server Databases
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
Search Table And Field In All Database And Return Field Value
In this script, we can search a Field and Table in all databases on the server, returning the Field value.
2013-11-15
11 reads
Search for String in all columns
Find all columns containing a string value across all tables and schemas.
2012-11-07 (first published: 2012-10-12)
1,820 reads
sp_Find2
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,106 reads
Searching through SPs, Tables, Views
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,708 reads
A Search and Replace Script when Moving Objects from Prod to Test
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,329 reads
2010-02-15 (first published: 2010-01-18)
14,176 reads
Search in your T-SQL objects
This procedure searches for your criteria not only in code, but also in objectnames
2009-11-16 (first published: 2009-10-20)
1,071 reads
Blogs
2020 Advent of Code–Day 1
By Steve Jones
This series looks at the Advent of Code challenges. I started the Advent of...
Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 2)
By Kevin3NF
Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last...
One Chart at A Time Video Series
Jon Schwabish over at PolicyViz has created great initiative called the One Chart at...
Forums
SUM multiple tables GROUP BY column
I have the following SQL Server 2005 tables: create table Cars ( CarID int,...
SUM multiple tables GROUP BY column
I have the following SQL Server 2005 tables: create table Cars ( CarID int,...
Interesting bug in SQL 2016 CHOOSE
While trying, in SQL 2016 (13.0.5850.14), to see if CHOOSE allowed an inline query...
Ask SSC