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

2005-03-03 (first published: )

159 reads

Blogs

One Thousand SQL Saturdays (*ish)

By

This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...

Top Azure Synapse Analytics and Power BI questions

By

I have listed below the top questions I see from customers about Azure Synapse...

Pre-Conference Workshop and Sessions at PASS Summit

By

I’m pleased to announce that I will be presenting at PASS Summit. This year...

Read the latest Blogs

Forums

ROWLOCK UPDLOCK - Locks whole table

By SQLSACT

Hi All I came across the following query on one of my systems. SELECT...

Index scan

By hello.priyanka

Hi, I have a query as below: ;With P As (Select ProductID --Query that...

why cannot use ClientProcessID to trace data in SQL Server Profile.

By 892717952

A C/S system is running on a SQL Server database, and I get its...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers