2018-05-01 (first published: 2018-04-20)
746 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)
846 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
15 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,832 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,116 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,335 reads
2010-02-15 (first published: 2010-01-18)
15,304 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,072 reads
Blogs
The Diverse Data Platform–Dativerse.io
By Steve Jones
The other day I got a note from Ben Weissman the other day that...
Extended Events and Azure SQL Database
Knowledge of how your system behaves is vital to better control, maintain, and grow...
Daily Coping 19 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Buy oxycontin 80m,xanax,Oxycodone,Ritalin,Diazepam etc WhatsApp:+1(312) 379-9621
We are most reliable and efficient suppliers/distributor of all kinds of commonly used pain...
upgrade path to SQL 2019
I read the upgrade path for standard edition to SQL server 2019, the oldest...
Ask SSC