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
Introduction to SQL Server Query Store
Introduced with SQL 2016, Query Store was, probably without doubt, the most anticipated and...
Flyway with Multiple Folders
By Steve Jones
A customer asked about how they could organize their migration scripts in different ways...
Migrating from EverNote to Joplin
By Steve Jones
Recently I got a message that my Evernote subscription was going up. It’s been...
Forums
Database copy issue through - COPY DB WIZARD
I have a production server with SQL server 2016 version (13.0.5026.0) and a database...
Help with a SQL Unpivot
I am trying to use unpivot to extract some data, however, the results are...
how to de escalte a isolation level, and are there any implications.
hi, I have one nested transaction and want to deescalate to outer transaction's isolation/...
Ask SSC