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)
161 reads
Recently I was looking through DBA.StackExchange when I saw a pretty simple question that...
By Steve Jones
Today’s coping tip is to write down three things you appreciate about yourself. I...
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...
I know there are lambda versions. But I want to know if this can...
Hi. Publisher stop sending transaction to AOAG primary replica whenever AG failover. It seems...
I'm in the process of replacing a sql server 2012 with 2019. How do...
Ask SSC