Wednesday, 2 October 2013

Find any content SQL Store Procedure And View



CREATE FUNCTION [dbo].[Search]
(
    @str VARCHAR(100)
)
RETURNS TABLE
RETURN
    SELECT
        DISTINCT    s.name AS SchemaName,
        o.name AS ObjectName,
        o.type_desc AS ObjectType
    FROM sys.objects o
    INNER JOIN syscomments c ON c.Id = o.object_id
    INNER JOIN sys.schemas s ON s.schema_id = o.schema_id
    WHERE
    is_ms_shipped = 0 AND c.text like '%' + @str + '%'




No comments:

Post a Comment