Technical Article

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 […]

You rated this post out of 5. Change rating

2004-03-31

271 reads

Blogs

T-SQL Tuesday #178–A Recent Technical Problem

By

This month we have a good invitation from Deepthi Goguri, where she asks us...

WordPress.com and Developers: Roadmap Update

By

Where we've been and where we're going.

Redgate Clone Graduating Images

By

I wanted my own custom image in our internal Redgate Clone cluster, so I...

Read the latest Blogs

Forums

GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

How to Add a New Shared Disk to a WSFC as a SQL Resource

By muhkam

Comments posted to this topic are about the item How to Add a New...

Setting Emergency State

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Setting Emergency State

Visit the forum

Question of the Day

Setting Emergency State

Which server role(s) can set a database to the Emergency State?

See possible answers