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)
174 reads
By Steve Jones
I had someone ask me about using triggers to detect changes in their tables....
By Brian Kelley
Redgate is offering 13 PASS Summit scholarships which not only includes the 3-day ticket...
By Kevin3NF
Configuration, Performance, and Unnecessary Usage TempDB is the SQL Server equivalent of a junk...
Folks, Looking for advice on the best way to import a package. I hope...
Hi, I have two fact tables (say FactA, and FactB), that are joined/shared...
Can anybody advise on how i go about balancing threads to each node. As...
I have DDL trigger code that I'm working on in SQL Server 2022, but I am concerned that we might end up with multiple triggers firing and the response to the user is delayed. If I want to check how many triggers have fired, or are nested, how can I do this in my code?
See possible answers