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.

 

Visual Studio 2015 PerfTips: Performance Information at-a-glance while Debugging with Visual Studio – Microsoft Application Lifecycle Management – Site Home – MSDN Blogs

PerfTips: Performance Information at-a-glance while Debugging with Visual Studio – Microsoft Application Lifecycle Management – Site Home – MSDN Blogs.

Announcing ASP.NET features in Visual Studio 2015 Preview and VS2013 Update 4 – .NET Web Development and Tools Blog – Site Home – MSDN Blogs

http://blogs.msdn.com/b/webdev/archive/2014/11/12/announcing-asp-net-features-in-visual-studio-2015-preview-and-vs2013-update-4.aspx