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: 2005-02-25)
159 reads
By Steve Jones
This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...
By James-Serra
I have listed below the top questions I see from customers about Azure Synapse...
I’m pleased to announce that I will be presenting at PASS Summit. This year...
Hi All I came across the following query on one of my systems. SELECT...
Hi, I have a query as below: ;With P As (Select ProductID --Query that...
A C/S system is running on a SQL Server database, and I get its...
Ask SSC