SP to find text in code objects in all user db's.

This script creates a stored procedure which helps to find text in all of your code objects in all your databases. It searches the code of SP's, UDF's, views, triggers, and it searches in all databases.Output is a result set with DbName, ObjectName and ObjectType.Advantages are- works reliable also with source codes longer than 4000 […]

2004-03-31

263 reads

Blogs

Spark .NET - Spark ML TF-IDF

By

Spark ML in .NET for Apache Spark Spark is awesome, .NET is awesome, machine...

Daily Coping 7 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Publish ADF from code to further environments

By

Struggling with #ADF deployment? adf_publish branch doesn’t suit your purposes? Don’t have skills with PowerShell? I have good...

Read the latest Blogs

Forums

First Time using SUBSTRING

By Bron Tamulis

Okay - I have a text field that i need to 'wildcard' search and...

Help needed in checking dates spans and status

By dhanekulakalyan

Hello All, I have a requirement where we need to merge spans if the...

List of all OWNERS, not db_owner

By Footage

How can I get a list of all database owners in an instance (not...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers