How to search/FIND for a text in body of Procedure.

in #sql • 6 years ago

SELECT name
FROM sys.procedures
WHERE Object_definition(object_id) LIKE '%TextYouWantToSearch%'

select * from sys.syscomments c
inner join sys.objects o on c.id=o.object_id
inner join sys.schemas s on s.schema_id=o.schema_id
where text like '%dim%'

6 years ago in #sql by
$0.00
    1 vote
    Reply 0

    Coin Marketplace

    STEEM 0.06
    TRX 0.32
    JST 0.060
    BTC 66604.70
    ETH 2023.19
    USDT 1.00
    SBD 0.50