2018-05-01 (first published: 2018-04-20)
661 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)
828 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
7 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,802 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,092 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,704 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,313 reads
2010-02-15 (first published: 2010-01-18)
11,500 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
Information Measurement with SQL Server, Part 4.9: The Bregman Divergence
By Steve Bolton …………Before closing out this long-delayed segment on stochastic information distances, I...
Let’s Talk About The Cloud
I’m launching a new initiative called the Community Circle Cloud Conversation Club (c5 for...
Daily Coping 29 May 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Daily Coping 29 May 2020
Today’s tip is today link your decisions and choices to your purpose in life....
Week Ending Thursday, can some one tweek my code?
What I have missed from this code? I'm trying to show the DateTimeRaised field...
The Matchbox Database
Comments posted to this topic are about the item The Matchbox Database
Ask SSC