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 James-Serra
I recently blogged about Query Acceleration for ADLS, which also applies to Azure Blob...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
As part of the Community Circle effort at Redgate, we’ve released a cookbook: A...
Hello all, i would like to send a html Mail with sql server. But...
Hello all, I really need your help – I want to use the sample...
Hi Forum, I have a table that uses the script below to create fields...
Ask SSC