a guest Jan 24th, 2020 59 Never
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
RAW Paste Data