It is very tedious to find out all Database objects (functions, stored procedures) containing a particular string.
Here is the script to get it-
DECLARE @Search varchar(255) SET @Search='texttofind' 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+'%' ORDER BY 2,1
I like this post, enjoyed this one thankyou for putting up.
Thank you for sharing your issues on weblog. it’s most most likely that we have comparable interests. 1 factor are highly valuable to me.
Hi there! Do you use Twitter? Iâ??d like to follow you if that would be okay. Iâ??m definitely enjoying your blog and look forward to new posts.
Thank you for the good writeup. It in fact was a leisure account it. Glance complicated to more delivered agreeable from you! However, how could we communicate?