While working with a big database with hundreds of stored procedures, it is a pain if you don't remember the name of certain methods. So, a way to look for the method is searching by text.
[USE DATABASE_NAME]
SELECT OBJECT_NAME(object_id)
FROM
sys.sql_modules
WHERE
definition LIKE '%text_to_search%'
Reference:
http://stackoverflow.com/questions/4812962/text-search-in-stored-proc-sql-server
Hi,One of the most frustrating aspects of any badly designed website is not being able to find something that you feel is on the website in Web Design Cochin, or worse you have seen on the website before and just can't find now. The whole area of Information architecture (to give it its proper title), is vital to getting your website working.Thanks.....
ReplyDelete