Post reply

Find string occurrance

  • September 17, 2009 at 8:37 am

    #210943

    What SQL can I use to find a value contained in stored procedures or triggers in a DB?

  • September 17, 2009 at 8:45 am

    #1055023

    select object_name(m.object_id) as ObjectName

    from sys.sql_modules m

    join sys.objects o on o.object_id = m.object_id

    where definition like '% string to search for%'

    and o.type in ('P', 'TR')

    Karl
    source control for SQL Server

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply