2018-05-01 (first published: 2018-04-20)
1,171 reads
2018-05-01 (first published: 2018-04-20)
1,171 reads
Script that searches every object in a database for a specific string.
2016-06-20 (first published: 2016-05-02)
1,026 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
156 reads
Find all columns containing a string value across all tables and schemas.
2012-11-07 (first published: 2012-10-12)
2,048 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,171 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,735 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,457 reads
2010-02-15 (first published: 2010-01-18)
22,541 reads
This procedure searches for your criteria not only in code, but also in objectnames
2009-11-16 (first published: 2009-10-20)
1,080 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Comments posted to this topic are about the item Create an HTML Report on...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Comments posted to this topic are about the item Be Wary of Data
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate, o_orderkey, o_custkey, o_storekey FROMdbo.orders WHEREo_orderkey = 3877;