Simple SQL script for searching for a certain word in all EPiServer 6 pages

The fkPageID value points to the actual page id which you can search for in EPiServer UI.
The string could be in a page in the Recycle Bin or maybe even in a previous page version…

SELECT *
FROM [myEpi6db].[dbo].[tblProperty]
where
string like '%support@mysite.com%'
or LongString like '%support@mysite.com%'

This is on a EPiServer 6r2 db.

 

Leave a Reply

Your email address will not be published. Required fields are marked *