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

243 reads

Blogs

Azure Storage tips

By

As a followup to my blog post Azure Data Lake Store Gen2 is GA,...

Managing Agent Jobs on Availability Group Servers

By

As always, the scripts in this post can also be found on our Git...

Permissions required for row counts to show up on Object Explorer Details

By

I ran into a rather obscure permissions problem the other day. Since I wasn’t...

Read the latest Blogs

Forums

On Looking and Acting the Part

By Phil Factor

Comments posted to this topic are about the item On Looking and Acting the...

How to make group by Revision_ID and when repeated display last check date separ

By ahmed_elbarbary.2010

problem How to make group by Revision_ID and when repeated display last check date...

Why Getting Data Right Matters

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Why Getting Data Right Matters,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers