Search in the content of stored procedures

If you need to search in the content of all the stored procedures, here’s a quite good example to do it.


SELECT DISTINCT
       o.name AS Object_Name,
       o.type_desc
  FROM sys.sql_modules m
       INNER JOIN
       sys.objects o
         ON m.object_id = o.object_id
 WHERE m.definition Like '%Search string%';

223 thoughts on “Search in the content of stored procedures”

  1. I intended to create you the tiny observation to finally say thanks again regarding the lovely basics you have shown on this website. It is simply wonderfully generous of people like you to allow freely just what most people could possibly have marketed for an ebook to earn some cash for their own end, and in particular now that you could possibly have tried it in the event you decided. The ideas also served to provide a good way to know that other individuals have the same desire much like mine to grasp more when considering this matter. I believe there are a lot more pleasurable occasions up front for individuals who scan your blog.

  2. I simply desired to thank you very much again. I’m not certain the things I could possibly have achieved without the creative ideas shown by you directly on such a theme. It became a real frustrating problem for me personally, however , coming across a specialized mode you managed the issue took me to weep over happiness. I am just happier for the work and hope you recognize what an amazing job that you’re putting in training most people by way of a site. Most probably you have never come across all of us.

  3. Thank you a lot for providing individuals with remarkably memorable chance to check tips from here. It is often very nice and as well , jam-packed with fun for me personally and my office fellow workers to visit your site nearly thrice a week to find out the newest secrets you have. Not to mention, I am also usually happy with your effective secrets you serve. Some 1 points in this posting are unquestionably the finest we’ve ever had.

  4. My husband and i got so happy that John could complete his web research while using the ideas he got while using the web site. It’s not at all simplistic just to always be giving away tips and tricks that many people may have been trying to sell. And we all do know we have you to thank because of that. These illustrations you made, the easy site navigation, the relationships your site help to foster – it’s got many overwhelming, and it’s really letting our son in addition to us believe that this topic is pleasurable, and that’s especially vital. Thanks for all!

  5. I not to mention my friends have already been following the great recommendations on your site then the sudden I had a horrible suspicion I had not thanked the site owner for those techniques. All the women appeared to be absolutely warmed to learn all of them and have now in actuality been using those things. I appreciate you for getting so helpful and for pick out these kinds of very good guides millions of individuals are really eager to be aware of. Our honest regret for not expressing appreciation to sooner.

  6. My spouse and i were really joyful Edward could finish up his reports while using the precious recommendations he discovered from your own weblog. It is now and again perplexing just to possibly be giving freely thoughts which often the others may have been making money from. And we also acknowledge we need you to appreciate for that. The most important illustrations you have made, the straightforward web site menu, the friendships you can make it possible to instill – it’s got everything fabulous, and it is helping our son and us understand the article is brilliant, which is certainly extraordinarily essential. Many thanks for everything!

  7. I would like to convey my affection for your kind-heartedness supporting folks that really want help on this one niche. Your very own commitment to passing the solution all through has been particularly invaluable and have made folks much like me to attain their endeavors. Your new invaluable guideline entails a lot to me and a whole lot more to my colleagues. Thanks a lot; from each one of us.

  8. I simply had to thank you so much again. I am not sure what I would have sorted out in the absence of the tips shared by you about my concern. It previously was a frightening situation for me, but understanding the very well-written technique you processed it forced me to cry with delight. Now i’m happy for this support as well as believe you know what an amazing job that you are providing teaching many others through your website. Most probably you’ve never encountered any of us.

  9. I and my guys ended up reviewing the good information and facts on the website and instantly I had an awful feeling I never thanked the web blog owner for those strategies. Those people happened to be totally warmed to read through them and have in truth been tapping into these things. We appreciate you turning out to be indeed considerate and also for making a decision on variety of extraordinary areas millions of individuals are really needing to be aware of. Our honest regret for not saying thanks to earlier.

  10. I enjoy you because of your entire efforts on this web page. Kate loves engaging in research and it’s obvious why. Most of us learn all relating to the dynamic means you convey both useful and interesting guidelines by means of this web blog and in addition inspire response from the others on this concern while our favorite simple princess is really learning a great deal. Enjoy the remaining portion of the new year. You have been doing a stunning job.

  11. I would like to convey my appreciation for your kindness giving support to individuals who actually need assistance with in this matter. Your special commitment to passing the solution all-around was surprisingly significant and have specifically helped somebody like me to arrive at their pursuits. Your personal valuable help and advice indicates a whole lot a person like me and far more to my mates. Thank you; from each one of us.

  12. I simply wanted to thank you so much once more. I do not know the things I could possibly have gone through without the type of methods revealed by you relating to my area. It had been an absolute troublesome circumstance for me personally, but coming across your skilled fashion you processed the issue took me to jump over fulfillment. I will be grateful for the help and then pray you really know what a great job you have been carrying out educating some other people through a blog. Most probably you’ve never met any of us.

  13. I want to show my admiration for your kind-heartedness giving support to women who absolutely need guidance on in this concern. Your special commitment to getting the message across was remarkably insightful and has regularly empowered folks just like me to attain their aims. The useful publication denotes so much a person like me and still more to my peers. Thank you; from everyone of us.

  14. I truly wanted to post a simple remark to be able to express gratitude to you for these superb guidelines you are showing at this website. My rather long internet lookup has at the end of the day been honored with good points to talk about with my visitors. I ‘d state that that most of us readers actually are really fortunate to be in a superb website with many lovely individuals with good ideas. I feel quite fortunate to have seen your web page and look forward to plenty of more exciting moments reading here. Thank you again for everything.

  15. I would like to show my affection for your kindness supporting individuals who actually need assistance with this one subject. Your very own dedication to passing the solution across has been wonderfully important and have really helped guys and women like me to arrive at their ambitions. Your invaluable useful information implies a great deal a person like me and far more to my colleagues. Regards; from all of us.

  16. Thanks for your whole work on this site. Gloria takes pleasure in managing investigations and it’s obvious why. My partner and i notice all concerning the dynamic method you provide effective strategies on the web site and recommend contribution from visitors about this subject matter then our favorite princess is truly starting to learn a lot of things. Have fun with the rest of the year. Your conducting a great job.

  17. I precisely wished to say thanks again. I’m not certain the things that I would’ve accomplished in the absence of the entire strategies provided by you relating to my concern. It was actually a challenging dilemma in my position, however , observing your specialised manner you managed it made me to cry for delight. Now i’m happier for your help and trust you are aware of a great job you have been accomplishing teaching men and women thru a web site. I know that you haven’t encountered all of us.

  18. I have to express thanks to you just for bailing me out of such a challenge. After exploring throughout the the net and coming across opinions which were not productive, I was thinking my life was done. Living without the presence of solutions to the issues you’ve resolved all through your post is a serious case, as well as the ones that could have negatively damaged my entire career if I had not discovered the blog. The knowledge and kindness in taking care of all the things was invaluable. I’m not sure what I would have done if I had not come upon such a subject like this. It’s possible to at this point relish my future. Thank you very much for your impressive and results-oriented help. I won’t be reluctant to propose your site to any person who wants and needs guidance about this problem.

  19. Needed to create you the bit of note in order to thank you yet again for all the splendid ideas you have documented in this case. This is so remarkably open-handed of you to give without restraint what a few individuals would have made available for an e book to help with making some dough on their own, specifically given that you could have tried it if you decided. The good ideas in addition acted as a great way to recognize that many people have the identical zeal like mine to know the truth great deal more pertaining to this issue. I think there are a lot more pleasurable situations up front for individuals that find out your blog post.

  20. A lot of thanks for all your work on this web site. My mother really likes working on investigation and it’s really obvious why. Most people hear all concerning the powerful method you present reliable thoughts via your web site and therefore boost contribution from people on the theme so our own simple princess is without a doubt learning a lot. Enjoy the rest of the year. You are performing a great job.

  21. [url=http://genericcolchicine.com/]colchicine[/url] [url=http://valtrexcost.com/]cost of valtrex[/url] [url=http://metformin850.com/]metformin 850[/url] [url=http://ventolinhfainhaler.com/]ventolin hfa inhaler[/url] [url=http://azithromycinwithoutprescription.com/]buy azithromycin[/url] [url=http://lipitor20.com/]lipitor buy[/url] [url=http://motilium10mg.com/]motilium online[/url] [url=http://tretinoincream01.com/]tretinoin cream .1[/url]

Leave a Reply

Your email address will not be published. Required fields are marked *