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

Why i use a smaller docker image part I

By

What is Docker? Docker is a famous platform for building, shipping, and running container...

New Job -> Week 2 -> Creating a Checklist

By

This is part of a series of new job blog posts. You can find...

SQL Server 2022 Administration Inside Out

By

SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...

Read the latest Blogs

Forums

SQL blocking caused by running ALTER VIEW script

By webrunner

Hello experts, One of our developers tried to alter a view and reported to...

script to find the frequent used login information in the sql

By pols

Hi, Kindly some one share the script or query to get the login information...

SQL Server Agent is not expanding and Jobs are not visible

By pols

Hi, We are not able to expand the SQL SERVER Agent. It is taking...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers