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

269 reads

Blogs

How Long Will It Take to Learn SQL? The Truth Might Surprise You

By

In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...

Flying Halfway Around the World to Australia

By

I leave tonight for Australia. I was in London 3 days ago, so this...

Dealing with Change – Two Resources

By

As I look at the state of information technology today, I see one constant:...

Read the latest Blogs

Forums

Table with FK(s) to other columns within the table

By BOR15K

Hello All, I have recently joined a project, where main, core tables with millions...

SQL 2017 throwing BugCheck on differential database restore

By arran.franklin

Long time listener, first time caller. I have a problem that my usual bag...

cluster node quarantined

By StillaLearner

evening All hoping someone can shed some light - I have a (originally) 2...

Visit the forum

Question of the Day

Using Table Hints in a Query

How many table hints can I include in a query?  

See possible answers