Technical Article

Finding Procedures with a specified text

This script will give the text of all the procedures with occurences of a specifc variable. Syscomments has a limitation of 4000 characters but this script overcomes that as it uses DMO. The output is generated in a text file. If you want the name of the procedure only. replace the line where it says […]

You rated this post out of 5. Change rating

2005-03-03 (first published: )

170 reads

Blogs

T-SQL Tuesday #182: Personal Integrity

By

It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...

SQL Saturday Oregon & SW Washington 2024

By

Wow I am so late in posting these notes! But this conference was amazing,...

Challenges Enterprises Face When Adopting AI

By

The post Challenges Enterprises Face When Adopting AI appeared first on Joyful Craftsmen.

Read the latest Blogs

Forums

Sparse Column Storage

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Sparse Column Storage

The Managed Cloud Database Options

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Managed Cloud Database Options

Stairway to Snowflake Level 6 - Creating and Cloning Snowflake Databases

By Mike McQuillan

Comments posted to this topic are about the item Stairway to Snowflake Level 6...

Visit the forum

Question of the Day

Sparse Column Storage

When does a column declared as SPARSE use no storage?

See possible answers