SELECT name
FROM sys.proceduresWHERE Object_definition(object_id) LIKE '%YourKeyword%'
Best Wishes,
LadyinProgramming
Showing posts with label query find text in stored procedure sql server. Show all posts
Showing posts with label query find text in stored procedure sql server. Show all posts
Sunday, June 14, 2015
Find stored procedure containing text in sql server
Use this query to find stored procedure containing text in sql server:
WHERE Object_definition(object_id) LIKE '%YourKeyword%'
Best Wishes,
LadyinProgramming
WHERE Object_definition(object_id) LIKE '%YourKeyword%'
Best Wishes,
LadyinProgramming
Subscribe to:
Posts (Atom)