SQL Server Performance Blog where milliseconds matter

Hello Friend, Today we have a little but useful post. I know many of you already know how to search for text inside a trigger or inside a stored procedure. But for those who still don't know. How to find a text inside a SQL Server trigger or procedures?   This is the simple T-SQL string: SELECT DISTINCT O. NAME AS OBJECT_NAME,O. TYPE_DESC FROM SYS.SQL_MODULES M JOIN SYS.OBJECTS O ON M. OBJECT_ID =O. OBJECT_ID WHERE M. DEFINITION LIKE '%<TEXT_TO_SEARCH_FOR> %'     A simple example..   Define a trigger:   CREATE TRIGGER TR_ORDRIG_UPD ON ORDRIG AFTER INSERT AS BEGIN   UPDATE T     SET T . TOTQTA1 = TOT . TOTQTA1   FROM dbo . ORDTES T     JOIN INSERTED I ON I . IDORDTES = T . ID        CROSS APPLY ( SELECT SUM ( R . QTA1 ) AS TOTQTA1 FROM dbo . ORDRIG R WHERE R . IDORDTES = T . ID ) AS TOT END   And now exec...