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
186 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
249 reads
Blogs
Daily Coping 4 Oct
By Steve Jones
Today’s coping tip is to free up time by canceling any unnecessary plans. I....
SQL Homework – October 2022 – Replication part 2
In August we started taking a look at replication. We learned some of the...
Function Vs. Performance
Recently I was looking through DBA.StackExchange when I saw a pretty simple question that...
Forums
Data replication tools and review
Hello expertise, Could you please suggest best tool for database replication? data replication on...
Version Controlling Lambdas
I know there are lambda versions. But I want to know if this can...
subscriber part of ALWAYSON
Hi. Publisher stop sending transaction to AOAG primary replica whenever AG failover. It seems...
Ask SSC