Technical Article

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

Today’s coping tip is to free up time by canceling any unnecessary plans. I....

SQL Homework – October 2022 – Replication part 2

By

In August we started taking a look at replication. We learned some of the...

Function Vs. Performance

By

Recently I was looking through DBA.StackExchange when I saw a pretty simple question that...

Read the latest Blogs

Forums

Data replication tools and review

By SQL Galaxy

Hello expertise, Could you please suggest best tool for database replication? data replication on...

Version Controlling Lambdas

By barakgodi

I know there are lambda versions. But I want to know if this can...

subscriber part of ALWAYSON

By SQL Galaxy

Hi. Publisher stop sending transaction to AOAG primary replica whenever AG failover.  It seems...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers