How to check if a page is customized/ghosted in SharePoint 2007

Question

How do you tell if a page is customized/ghosted in SharePoint 2007? Can I use SharePoint designer? I know that customized pages have an "i" icon next to them. However, what about page layouts in the masterpage gallery? I don't see an "i" next to the page layout, even after I customized it.

Is there a sql query I can run to determine this for sure?

Answer 1

I don't know about a SQL query, however you can use the following code block to test if a page is customized.

SPFile spFile = web.GetFile("_catalogs/masterpage/filename.aspx");
if (spFile != null && spFile.CustomizedPageStatus == SPCustomizedPageStatus.Customized)
{
    //spFile.RevertContentStream();
}

Answer 2

Doing a select against the content DB is a grey area in terms of supportability of your environment I think - some say that merely querying the content DB for information is ok provided you don't modify anything, other's (rightly*) say that circumventing all the security in place renders your environment completely unsupportable.

http://msdn.microsoft.com/en-us/library/bb861829.aspx

• = my own opinion :)

Answer 3

For page layouts for SP2007 i can recommend using Gary Lapointe's reghost stsadm extensions. That is if your employer accepts reflection code on production environments.

http://stsadm.blogspot.com/2007/09/re-ghosting-pages.html