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

What Agent Jobs are Running??

By

Do you run SQL Agent Jobs in your environment?  Do you know what is...

Unboxing SQL Clone 2020 for a PoC

By

When I got a new machine, I had SQL Clone on my old machine,...

Daily Coping 4 Aug 2020

By

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

Read the latest Blogs

Forums

Simple query question

By Mysterio

I'm new to SQL and I'm struggling to return a result set which I...

Filtering an R Dataframe

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Filtering an R Dataframe

Seeing the World Differently with a Coach

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Seeing the World Differently with...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers