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

272 reads

Blogs

T-SQL Tuesday #181: A Technology Present

By

It’s the last T-SQL Tuesday of the year, and it’s amazing to think we’ve...

Trace Flag 3625 Follow Up

By

Several months ago, I discussed my customer’s intention to enable trace flag 3625. Since...

Top 5 Advanced SQL Courses for 2025 (Must-Know)

By

Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...

Read the latest Blogs

Forums

Date data type not recognized with oledb type provider

By blom0344

Hello, We recently made the following reservation working with  VS2022  combined with the SSIS...

The Hash Join III

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Hash Join III

Continuous Learning

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Continuous Learning

Visit the forum

Question of the Day

The Hash Join III

In a hash join, if all the build input does not fit in memory, what type of hash join is this?

See possible answers