Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROC [dbo].[system_searchInStoredProcs]
- (
- @str nvarchar(100)
- )
- AS
- BEGIN
- SELECT name sp, Object_definition(object_id) text
- FROM sys.procedures
- WHERE Object_definition(object_id) LIKE '%'+@str+'%'
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement