2018-05-01 (first published: 2018-04-20)
1,137 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)
998 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
155 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)
2,012 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,170 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,730 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,430 reads
2010-02-15 (first published: 2010-01-18)
21,975 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,079 reads
Blogs
Advice I Like: Focus on what’s important
By Steve Jones
Don’t let someone else’s urgency becomes your emergency. In fact, don’t be governed by...
India-US Tariff War: Is the Indian IT Sector at Risk?
By Rohit Garg
How U.S.-India Tariff Disputes Could Ripple Through the Indian IT Sector Although the newly...
Save BIG on Microsoft Azure Certification – Up to 100% Off!
By Rohit Garg
🌟 Why Microsoft Azure Certifications Are Beneficial for Your Career 🗓️ How to Schedule...
Forums
OpenQuery with Application Intent specified runs on primary node.
I have an Open query that runs on an Always On server via a...
What is a Failed Deployment?
Comments posted to this topic are about the item What is a Failed Deployment?
Generating a Series I
Comments posted to this topic are about the item Generating a Series I
Question of the Day
Generating a Series I
What is returned by this code in SQL Server 2022?
SELECT value FROM GENERATE_SERIES(4, 1);See possible answers