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: )

174 reads

Blogs

Moving to Rancher Desktop

By

I’ve been very happy with Docker Desktop for years, running it on both laptop...

Logging in Azure Data Factory data flows

By

(2025-June-15) Long gone are the days when a data engineer could simply focus on building...

ADF: Publish suddenly includes everything where it used to be incremental changes since the last publish

By

I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...

Read the latest Blogs

Forums

What is Between?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What is Between?

skipping the second line in a spreadsheet being read by ssis

By stan

hi, my new user provided a new multi tab (sales, customer etc. not what...

disable remote access

By goodtimecharlie

If I configure remote access to 0 on my servers, am I right in...

Visit the forum

Question of the Day

What is Between?

I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?

SELECT *
FROM dbo.Products
WHERE ProductID
BETWEEN 4 AND 7;

See possible answers