Find strings in text of stored procedures

Ussualy this kind of scripts queries sysobjects and syscomments like this:select distinct object_name(O.id)from syscomments as Cjoin sysobjects as O on O.id = C.id and o.type = 'P' -- search string only in stored procedureswhere C.text like '%insert into MyTable%'When the text of stored procedures, triggers, functions is over 4000 characters, it is saved in syscomments […]

2004-08-26

138 reads

Blogs

Quick 6 month check – how are those learning goals going…?

By

So in January I wrote a blog post on some goals I had this...

Power BI Monthly Digest – July 2019

By

In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I...

Read the latest Blogs

Forums

https://first2fitness.com/keto-charge/

By PeggyMinard

Gracious, and you may ponder—how'd things turn out with the bacon lovers? Their test...

Changing Hardware

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Changing Hardware

Always On AG

By Admingod

I was trying to create cluster for AG group and it fails to create...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Intersection

See possible answers