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

Daily Coping 23 Sep 2022

By

Today’s coping tip is to notice what you are feeling without any judgment. Today...

Snowflake – Where is the explain/execution plan?

By

Whatever your database background is you will have heard of an execution / explain...

Daily Coping 22 Sep 2022

By

Today’s coping tip is to ask a trusted friend to tell you what strengths...

Read the latest Blogs

Forums

how to change hard coded dates to ytd please

By asita

Dear Helpers, Below query is working fine giving me what i needed but if...

Couldn't allocate new page for database alert even the Database has free space

By ramana3327

Hi, We have a database. We received the alert Could not allocate new page...

Best Approach to move the databases in Always On

By ramana3327

Hi, We have Always on Server with one primary & 1 secondary ( Not...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers