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

2004-03-31

268 reads

Blogs

Hello world!

By

Welcome to WordPress. This is your first post. Edit or delete it, then start...

Daily Coping 2 Dec 2021

By

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

SQL Homework – December 2021 – Changing collation

By

I can only speak for the locations I’ve worked at of course, but in...

Read the latest Blogs

Forums

SQL Query Help on Time based query

By dcw8888

I have a following table (Contains script to generate the sample table with data):...

When to Use a Database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item When to Use a Database

SQL Server Data Masking: a comparison with Gallium Data

By maxtardiveau

Comments posted to this topic are about the item SQL Server Data Masking: a...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers