Menu ▼



Posted By :
avatarmrkraju
Total Views : 226

SQL Query to find specific text used in stored procedure

Below query will fetch the list of stored procedure names that uses the given specific text.

SELECT Name 
FROM sys.procedures 
WHERE OBJECT_DEFINITION(object_id) LIKE '%Search Text%' 






comments powered by Disqus


Search dotnetlearners.com