How to find a text inside SQL Server procedures / triggers?

by

here is a portion of a procedure I use on my system to find text….

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

More Related Contents:

  1. SQL Server history table – populate through SP or Trigger?
  2. T-SQL stored procedure that accepts multiple Id values
  3. Select columns from result set of stored procedure
  4. SQL Server Linked Server Example Query
  5. SQL Server: Query fast, but slow from procedure
  6. Insert Update trigger how to determine if insert or update
  7. Dapper.NET and stored proc with multiple result sets
  8. How to list all dates between two dates [duplicate]
  9. SQL Server sp_msforeachtable usage to select only those tables which meet some condition
  10. EXEC sp_executesql with multiple parameters
  11. T-SQL Dynamic SQL and Temp Tables
  12. How do I find a stored procedure containing ?
  13. How do I search an SQL Server database for a string?
  14. Calling an API from SQL Server stored procedure
  15. How to: Create trigger for auto update modified date with SQL Server 2008
  16. error when inserting into table having instead of trigger from entity data framework
  17. Handling date in SQL Server
  18. Retrieve data from stored procedure which has multiple result sets
  19. Programmatically retrieve SQL Server stored procedure source that is identical to the source returned by the SQL Server Management Studio gui?
  20. Calling stored procedure using VBA
  21. SQL Server ON DELETE Trigger
  22. Avoid Naming User Stored Procedures SP% or SP_%
  23. Execute stored procedure with an Output parameter?
  24. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  25. Is there an “IF EXISTS” test for a linked server?
  26. Trigger to fire only if a condition is met in SQL Server
  27. Python – pyodbc call stored procedure with parameter name
  28. SQL Server stored procedure return code oddity
  29. Populate Dataset With Table Names From Stored Procedure
  30. How to cleanse (prevent SQL injection) dynamic SQL in SQL Server?

Leave a Comment