Check Umbraco For Lorem Before Go Live

Before going live with Umbraco you may want to run a quick check for that pesky lorem ipsum. It’s better than tripping over it after putting a site live!

Well the following SQL will find nodes with property data containing ‘lorem’. You can alter the string in the @ToFind variable.

DECLARE @ToFind varchar(max)
SET @ToFind = 'lorem'

SELECT *
FROM cmsDocument doc
WHERE doc.newest = 1
AND 
(
    SELECT COUNT(*) 
    FROM cmsPropertyData pd 
    WHERE pd.versionId = doc.versionId
        AND (datanvarchar LIKE '%' + @ToFind + '%' OR dataNText  LIKE '%' + @ToFind + '%')
) > 0