Veritabanı Arası Sorgulama

SELECT  obj.Name as SPName,
                              --modu.definition as SPDefinition,
        obj.create_date as CreationDate,
        obj.modify_date as LastUpdateDate,
                              obj.type 
FROM    sys.sql_modules modu
        INNER JOIN sys.objects obj ON modu.object_id = obj.object_id
        AND modu.definition LIKE '%Örnek Yazı.%'
Order By obj.Name

Like yerine kullanılabilecek hızlı full text sorgusu : 
CONTAINS(KOLONADI,'"ARANAN İÇERİK"')