Geeks With Blogs
Nouman Zakir while (true) { Post.NewArticle(); }

Method to retrieve every text inside the stored procedures of a database

SELECT B.Name, *
FROM syscomments A INNER JOIN sysobjects B
ON A.id = B.id
WHERE A.text like '%tblNames%'

Posted on Monday, February 2, 2009 12:43 AM SQL | Back to top


Comments on this post: Find text in SQL stored procedures

# re: Find text in SQL stored procedures
Requesting Gravatar...
This came in handy!
Left by Jef Claes on Feb 02, 2009 12:14 PM

# re: Find text in SQL stored procedures
Requesting Gravatar...
thanks.. its really helpful.
Left by Josh on Feb 10, 2009 3:07 PM

# re: Find text in SQL stored procedures
Requesting Gravatar...
Thank you
Left by ramya on Apr 19, 2012 12:46 AM

# re: Find text in SQL stored procedures
Requesting Gravatar...
Thanks for sharing.
Left by Saquib on Apr 23, 2012 2:48 PM

# re: Find text in SQL stored procedures
Requesting Gravatar...
Used it again. Thanks
Left by Saquib on May 01, 2012 3:37 PM

# re: Find text in SQL stored procedures
Requesting Gravatar...

SELECT name
FROM sys.procedures
WHERE Object_definition(object_id) LIKE ‘%strHell%’

For more details:
http://www.zilckh.com/how-to-search-a-text-in-stored-procedure-trigger-function-or-view/
Left by Davinder on Aug 21, 2013 7:32 PM

# re: Find text in SQL stored procedures
Requesting Gravatar...
Reading this post I am able to find the text in SQL stored procedures. I think this is the simplest way to do this procedure and I am very happy to get such an easy method. Thank you very much for sharing this post here!


house cleaning services san jose
Left by Kevin on Dec 29, 2015 9:11 AM

Your comment:
 (will show your gravatar)


Copyright © Nouman Zakir | Powered by: GeeksWithBlogs.net