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 Rayis Imayev
(2020-Jan-28) This blog post is a followup to my previous post about DevOps (CI/CD) for...
I wrote a short blog post about the misperception that Profiler was easier than...
If you read the title to this post and your first thought was That’s...
What is the fastest way to load a file in SQL Server Table ?...
Im an Oracle DBA by trade and been tasked with setting up transaction replication...
Hi Experts, Currently we are using SQL Server and Database Mail to send reports...
Ask SSC