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

2005-03-03 (first published: )

161 reads

Blogs

Azure Cosmos DB – HTAP using Azure Synapse Link

By

I haven’t done much blogging in the last 6 months. My last article was...

Azure Cosmos DB – HTAP using Synapse Analytics

By

I haven’t done much blogging in the last 6 months. My last article was...

Power BI Meets Programmability – TOM, XMLA, and C#

By

For anyone who read the title of this and immediately thought, “Oh no, I...

Read the latest Blogs

Forums

How to do Join

By patla4u

Hello, I am looking for output where EG_RequestID = 175998968 and Reissue from paymentID...

Connect to PostgreSQL as an External Data Source using PolyBase

By JerodJ

Comments posted to this topic are about the item Connect to PostgreSQL as an...

Growing and Keeping Up

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Growing and Keeping Up

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers