Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @Search varchar(255)
- SET @Search='[10.10.100.50]'
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement