Global Database Field Search
Search all text fields in a database for a literal string.Outputs SQL statements to query analyser window, which can then be run in a new window.
2004-02-10
201 reads
Global String Search & Replace In All DB Fields
Stored procedure to search every field in the database for a string literal. Run the stored procedure in Query analyser, which will output sql statements to do the search. The output of these searches will be the update sql, which again should be pasted into a query analyser window. As the stored procedures do not […]
2004-02-10
255 reads
Blogs
Monday Monitor Tips: Searching Permission Changes
By Steve Jones
During a demo of Redgate Monitor Enterprise to a customer, they asked about how...
SQL Bits 2025 Wrap
By Steve Jones
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...
Get Certified in Microsoft Azure Data Fundamentals (DP-900) FAST with NO Experience Needed
By Rohit Garg
As data becomes the backbone of modern business, understanding how to manage and analyze...
Forums
SQL Server 2008 to SQL Server 2022
Hi, Is it possible to upgrade from sql server 2008 to sql server 2022,...
The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
Question of the Day
Using Heaps
When does Microsoft recommend using a heap as a table structure (no clustered index)?
See possible answers