SQL Query to show dis-inherited sub-sites

Here is a SQL query I came up with quickly to find all dis-inherited sites in a content database: use <content_db>select Title, FullUrl from allwebswhere ParentWebID <> FirstUniqueAncestorWebID AND id = FirstUniqueAncestorWebId AND DeleteTransactionId = 0xorder by FullUrl For you coders, you can use “SPPermissionCollection.Inherited” Propertyhttp://msdn.microsoft.com/en-us/library/microsoft.sharepoint.sppermissioncollection.inherited(v=office.12).aspx

0

SharePoint 2010 – Error in crawl logs on Gantt.aspx ….

Customer getting numerous errors in their SharePoint 2010 search crawl logs… all pointing to Gantt chart views… Error message: The SharePoint item being crawled returned an error when attempting to download the item. Solution: Open Regedit on your search server. Goto: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\14.0\Search\Global\Gathering Manager Change “UserAgent” from  “MSIE 4.01” to “MSIE 8.0” Restart server &…

0

SharePoint Server Search – Error Stopping

Today, I had an issue with SharePoint 2010 Server Search service on a Project Server 2010 farm showing Error Stopping, it wouldn’t go away after I deleted a Seach Service Application that was failing. To resolve, I had to use the following steps: Stop service: SharePoint Server Search 14 Run in Powershell: get-spenterpriseseachserviceinstance Run in…

0

Get rid of old unused SP2010 service app pools

Whenever you create/recreate the “fun & stress-free” User Profile Service Application in SP2010, you have to create/select an Application Pool in IIS to attach it to. But what if you want to delete old app pool(s) that you have created & no longer want??? Poweshell has a neat command line to do exactly just that:Remove-SPServiceApplicationPool…

0

February / March 2012 CUs for SharePoint 2010 have been released to the public…

March 7, 2012 – SharePoint 2010 Cumulative Updates…   KB 2597132 – SharePoint Foundation 2010 KB 2597150 – SharePoint Server 2010 KB 2597152 – SharePoint Server 2010 with Project Server   —   Description of the SharePoint Server 2010 cumulative update package (SharePoint server-package): March 7, 2012   ***Make sure you run the Config Wizard…

0